Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1197 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1197 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1197 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

133 Brimstone Academy Ct
Olney, MD 20832
Ann B Boone with Columbia, original listing - (888) 536-0216

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,770,000
Beds: 6
Baths: Full: 5, ½: 1
Status: Active
SqFt: --
Agency: Columbia
Agency Phone: (888) 536-0216

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2012
Notes: LUCKY YOU **FALL IN LOVE * * TOLL BROTHERS GEM*1 OWNER MODEL HOME*TOLL'S VISION OF DISTINCTIVE LUXURY LIVING IN THIS CONTEMPORARY HARDING FARMHOUSE MODEL* *HIGH END VENDORS & ARTISAN INSTALLS*ESPECIALLY NOTEWORTHY IS THE ARCHITECTS VISION OF PARTNERING W/BOUTIQUE YORKTOWN CABINETRY IN MAJOR ROOMS I.E.GOURMET KITCHEN*CONSERVATORY*STUDY*PRIMARY SUITE *WALLED DISPLAY IN LOWER LEVEL&VANITY CABINETS * *TOLL DELIGHTED IN DESIGNING 1ST & SECOND FLOORS W/ 9 FT CEILINGS*C OFFERED &RECESSED, 2 STORY CEILINGS* STONE WALKWAY TO FRONT ENTRY PORCH* *DESIGNER LEADED GLASS FRONT ENTRY DOOR W/SIDELIGHTS+TRANSOM & BALDWIN LOCK *AWESOME2 STORY CENTER HALL RECEPTION AREA * DOUBLE STAIRCASE W/ WHITE BALUSTRADES*SITE LINE TO GREAT ROOM W/GAS FIREPLACE & MANTLE SURROUND* *LOVELY 2 PIECE CROWN MOLDING IN THE FOYER, LR, DR ROOM & PRIMARY BDRM*CHAIR RAIL IN LR & DR*3 1/2 CASING AROUND ALL DOORS** 5 1/4 BASEBOARD INSTALLED IN ALL FINISHED AREAS**3 OVER 6 PANES OF ANDERSEN LOW E HIGH PERFORMANCE INSULATED WINDOWS THAT ADD BEAUTIFUL LIGHT*BOTH STATIONARY &DOUBLE HUNG CASEMENT WINDOWS W/GRILL PANE INSERTS ARE ANOTHER ATTRACTIVE FEATURE*THE*LOWER &MAIN FLR HAVE ZONED CARRIER HEATING&COOLING* SECOND STORY HAS OWN ZONED HEAT PUMP ELECTRIC A/C BY CARRIER*HIGH END SONOS MEDIA SOUND SYSTEM IS THRU OUT ALL LEVELS OF THE HOUSE*WOW GOURMET KITCHEN HAS SUPERIOR LARGE ISLAND FOR SERVING BUFFET** STAINLESS STEEL APPLIANCES * LARGE LIGHTED WALK-IN SHELVED PANTRY W/ WOOD& GLASS DOOR ENTRY* LARGE S/S WALL OVEN &MICROWAVE****GOURMET 3 SECTION 5BURNER GAS STOVE W/DESIGNER EXHAUST HOOD TO OUTSIDE*LARGE OVEN TO COMPLEMENT IN WALL OVEN** S/S SINK W UPGDE FAUCET*DESIGNER PENDANT LIGHTING*HARDWOODS IN SOLARIUM BREAKFAST AREA W/SHIPLAP * SLIDER TO OUTSIDE TREX DECKING &BEAUTIFULLY PLANTED SPECIMEN GARDENS *FENCED BACK YARD W/ HANDSOME STONE FIREPLACE (NOT FIRE PIT) W/MANTLE W/ LOWER SURROUND WALL FOR SEATING&ENTERTAINING OR JUST RELAXING GREAT LEVEL .83 ACRE LOT*BACK TO FIRST FLR&ONE OF THE FAVORITE ROOMS FOR ENTERTAINING IS THE CONSERVATORY FLANKED BY THREE WALLS OF WINDOWS AND ONE WALL OF BUILT- INS TO HOLD YOUR COLLECTIONS WITH UNDER CABINETS FOR ORGANIZATION* HARDWOODS TOO**LARGE SCREEN TV* HALLWAY HAS AN OFFSET POWDER RM* THE STUDY ALSO HAS ANOTHER TERRFIC ARCHITECTURAL WALL W/ UNDER CABINETS*ENTER THRU GLASSED FRENCH DOORS OVERLOOKS GARDEN AREA*1ST FLR OFFSET IS A MUD ROOM JUST OFF THE GARAGE & LAUNDRY * BUILT IN WALL W/SEATING FOR HANGING COATS * *LAUNDRY HAS WHIRLPOOL DUET ENERGY STAR WASHER & DRYER W/FOLDING AREA AND UTILITY SINK* UPPER CABINETS FOR STORAGE* SECOND STORY HAS A GORGEOUS FULL LENGTH PRIMARY BEDROOM SUITE W/SITTING ROOM* BUILT-INS AND A SECONDARY BUILT IN FOR MORNING COFFEE SERVICE*HARDWOOD FLRS*RECESSED CEILING W/UPGRD FAN* DOWN TO THE PRIMARY BATH FLANKED BY 2 AWESOME CUSTOMIZED DRESSING ROOMS * DOUBLE VANITY SINKS & CABINETS*JACUZZI JETTED TUB*SEPARATE SHOWER W/ DESIGNER TILES*SEPARATE NECESSARY RM* TOWEL& TOILETRY CLOSET*LIGHTED HALLWAY GLASS PANED STORAGE CLOSETS* 2 MORE EN SUITE BEDRMS * A JACK AND JILL SUITE SERVES TWO OTHER BEDRMS*A GYM W/TVS IS ANOTHER PLUS TO THE SECOND FLOOR*LOWER LEVEL IS AN ABSOLUTE DELIGHT *FINISHED W/DESIGNER CUSTOM STAIRWAY CARPET* WALL TO WALL DISPLAY SHELVES *FULLY FINISHED TILED BATH*FRENCH DOORS LEADING TO INLAW/GUEST OR NANNY SUITE*LARGE CLOSET AND BUILT IN VANITY ACROSS ONE WALL* WINDOWS LET IN LOVELY LIGHTING* STONE WORK ARCHES ARE AROUND THE LIGHTED BAR AREA WINE FRIDGE *SINK & LOTS OF STORAGE FOR GLASSWARE* WALK OUT TO GARDENS* MOVIE ROOM *GAME RM & WINE AREA* LRG UTILITY STORAGE AREA*1ST LEVEL GLORIOUS ENTRY TO 3 CAR GARAGE W/STEEL DESIGNER DRS & LIFT MASTER OPENERS* PLUG IN FOR EV CHARGING**BRICK PAVERS **OLNEY THEATRE*MONTGOMERY COUNTY HOSPITAL* GREAT PUBLIC SCHOOLS* PRIVATE SCHOOLS ARE GOOD COUNSEL HIGH SCHOOL*ST JOHNS EPISCOPAL*SANDY SPRING* BOUTIQUE FUN SHOPPING*EASY COMMUTING*A TOTAL BEAUTY W/ SO MUCH MORE* COME TAKE A PEEK AT THIS MODERN DAY CLASSIC GEM**YOU WILL BE GLAD YOU DID****
MlsNumber: --
ListingId: MDMC2173582


Listing Provided By: Columbia, original listing
Phone: (888) 536-0216
Office Phone: (888) 536-0216
Agent Name: Ann B Boone
Disclaimer: Copyright © 2025 Long & Foster Real Estate. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1197 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Beth Close
Beth Close
ASCIIIron Valley Real Estate of Central Maryland
Call Today!: (240) 310-2984

Local Mortgage Pro

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1197 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Paul McCausland
Paul McCausland
ASCIIMeridian Bank
Office: (301) 605-9961

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App