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 = 2825 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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 = 2825 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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 = 2825 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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;

2412 Custis Road
Arlington, VA 22201

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,855,000
Beds: 6
Baths: 6
Status: Active
SqFt: 3760
Agency: G.E. Cranwell & Assoc., Ltd.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2021
Notes: Constructed and delivered in 2020 by design/build firm Morris Construction Company, this extraordinary Craftsman Style luxury home is in Arlington VA, within minutes of Washington D.C., Ronald Reagan Airport, Rt. 66 & Rt. 395, walking distance to Clarendon and Courthouse Metros, restaurants & shopping in the sought after Lyon Village neighborhood. With approximately 3,750 square feet of finished living space, the house has 6 bedrooms, 5 full baths and 1 half bath. The main level features 10-foot ceilings with crown molding, recessed lighting, Sonos built-in sound system, oak hardwood floors, and plantation shutters on all windows. Gourmet style, stainless steel and quartz kitchen featuring a 12' x 8' breakfast nook and a 7' x 4' center island with built-in storage. A Sub-Zero Refrigerator, 6 Burner G.E. Cafe Series Brushed Bronze Range, G.E. Profile Advantium Built-In Microwave/oven, Bosch Super Silence Dishwasher, Whirlpool Beverage Center, and Asko 24" Washer/Dryer accent the kitchen. Also located on the main level are the dining/living room, study/office, spacious family room with built-in gas fireplace.<br /> The first floor also has a bedroom with an ensuite, mudroom with built-in shelving, and a half bath. The incredible upper-level features oak hardwood floors, recessed lighting, plantation shutters on all windows, 4 bedrooms with 3 full baths; the primary suite features a large separate shower, double sinks and a large walk-in closet with built-in shelves and dresser. There is also a separate second floor laundry room with a built-in folding table, shelves, and a Maytag 27' washer/dryer. The lower-level features its own separate entrance, in-law/nanny bedroom with full bath, recreation room and a storage/utility room with built-in shelving. There is a large outdoor tool shed, off street parking for 3 cars, an amazing 26' x 8' covered front porch, and an outdoor gas grill hook-up. This property is situated on a completely fenced in lot with four easy access gates, paver driveway and a beautifully landscaped 7,943 sq ft corner lot.
MlsNumber: VAAR2042292


Listing Provided By: G.E. Cranwell & Assoc., Ltd., original listing
Name: G.E. Cranwell & Assoc., Ltd.
Phone: (703) 525-4994
Office Name: G.E. Cranwell & Assoc., Ltd.
Office Phone: (703) 525-4994
Agent Name: George Cranwell
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 = 2825 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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 Jurgen Gonzalez
Jurgen Gonzalez
ASCIICentury 21 New Millennium - Mannheim Group, LLC
Call Today!: (703) 732-8165

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App