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 = 3254 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 = 3254 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 = 3254 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;

14611 Manor Road
Phoenix, MD 21131
Carmen Zuniga with EXP Realty, LLC, original listing - (888) 860-7369

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $999,999
Beds: 5
Baths: Full: 3, ½: 2
Status: Active
SqFt: 4200 Square Feet
Agency: EXP Realty, LLC
Agency Phone: (888) 860-7369

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1989
Notes: Welcome to 14611 Manor Rd! This magnificent detached home boasts 5 bedrooms, 3 full baths, and 2 half baths, spanning an impressive 4,381 sq ft of remodeled living space. Nestled off the main road on a shared drive, it offers privacy and luxury in a serene setting.<br /> <br /> Upon entry, you're greeted by stunning hardwood floors and high ceilings that flow seamlessly into the chef's kitchen. This kitchen is equipped with marble countertops, a professional gas range with two ovens and a warming hood, and a Sub-Zero fridge, making it the heart of the home. The adjoining family room features vaulted ceilings and built-in surround sound, creating a perfect atmosphere for casual living and grand entertaining.<br /> <br /> Step outside to your own private oasis, featuring an enormous 50-foot-long in-ground pool, a built-in fire pit, and an oversized shed—perfect for extra storage or hobbies. The enclosed sunroom off the kitchen is ideal for a meal while overlooking your beautifully landscaped, secluded yard.<br /> <br /> The main floor laundry/mudroom, renovated in 2021, includes a full bath for added convenience. On the second level, you'll find four spacious bedrooms and the main suite, which offers a log-burning fireplace, a large en-suite bathroom, and ample walk-in closet space.<br /> <br /> The finished lower level is a dream retreat with a man/woman cave, an exercise room, and an updated half bath. There's even room to add another bedroom if desired. Enjoy the comfort and energy efficiency of new HVAC equipment installed in 2023.<br /> <br /> Located near top-rated schools, this home offers magnificent views, ample storage, and a variety of upgrades. It is a rare gem with plenty of space for relaxation and entertainment. Don't miss your chance—schedule a showing today!<br /> <br /> https://real.vision/14611-manor-road?o=u
MlsNumber: --
ListingId: MDBC2107342


Listing Provided By: EXP Realty, LLC, original listing
Phone: (954) 297-7718
Office Phone: (888) 860-7369
Agent Name: Carmen Zuniga
Disclaimer: Copyright © 2024 Bright MLS. 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 = 3254 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 Araminta Morton
Araminta Morton
ASCIIBennett Realty Solutions
Call Today!: (202) 409-3530

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App