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

125 Lake Holiday Road
Cross Junction, VA 22625
Erik Erdal with Winchester, original listing - (888) 536-0216

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $787,700
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: --
Agency: Winchester
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: 2024
Notes: Remarkable Custom New Construction on a level .41 Acre parcel. 4 (potentially 6) bedrooms, 3 Full baths + 1 Half Bath - 2,920 sq.ft finished above grade, plus 2,013 Unfinished (total almost 5,000 sq.ft.), all 2x6 Construction plus an unfinished Conditioned Basement for 2 additional bedrooms , game room + workout room and lots of storage located close to the Lake Holiday Security Gate entrance. This is a secure and gated Lake Community, access for owners and their guests only, with a 240 Acre fresh water lake, 3 beaches, clubhouse, walking trails and MUCH more located 15 minutes NW of Winchester Virginia. This home is FULLY READY for occupancy. Standing blue/gray insulated vinyl siding and all PVC (No Wood) window trim. Front Porch and Rear Deck have Custom tounge-in-groove pine ceilings, 4 foot wide concrete walkway to basement entrance and to the front door. Professionally landscaped and the entire parcel has sod installed (green/lush grass). The large Rear Deck is covered and has composite material flooring, ceiling fan and recessed lights and is accessed by the rear yard steps, the side door or via the sliding door off of the Family Room. Once inside, the ""daily"" entrance will be through the side garage door to the mudroom, sit down on the custom made bench for shoe removal. The Coat Closet and the Kitchen Pantry with wooden shelves are also located off the MudRoom, and so is the Laundry Room with sink and granite top - then swing right into the gourmet kitchen with a Large Island, all Granite Tops and Stainless Steel Appliances, Propane Gas Stovetop. The Dining Area has its own Butler (granite top again) Area and lots of windows. Back in from the Kitchen Island you can see the Propane Gas Fireplace across the great room with its natural Oak Wood Mantel, Stone Slab Hearth and a Stone Surround. On each side of the Fireplace you will find Cabinets, again wth Granite Tops and the Ship Lap horizontal details on the walls. All flooring is high mill LVT. At the far end of the house you will find the Master Bedroom with large windows overlooking the pasture, Tray Ceiling, and a Tiled Master Bathroom with 2 European sink tops (double vanity), a Custom Tiled Shower with Glass Door and a separate Water Closet, plus a rather large Walk-In daylight Closet. Also, on the first floor you will find the Second Bedroom with its adjoining Full Bath (tiled). So, 2 bedrooms on the first floor. The Oak Staircase with its custom handrail and spindles leads you to the second floor where you will find 3 large rooms, 2 Bedrooms and one large Family Room Above the Garage. All served by a tiled full bath with a tub off the Hallway. Basement. Conditioned and 9 foot ceilings, ready to be finished. Windows are installed so to make this area compliant and expandable for an additional 2 bedrooms if needed. There is also room for a Grand TV/Family Room, a Work Out Room..and more. The basement is also served by a 4 foot wide exterior concrete step for ingress/egress. LP Gas Trane Furnace. For detailed plans, go to the Frank Betz website and look for EMBRY HILLS - plan number 4239. This house plan is very similar.
MlsNumber: --
ListingId: VAFV2022824


Listing Provided By: Winchester, original listing
Phone: (888) 536-0216
Office Phone: (888) 536-0216
Agent Name: Erik Erdal
Disclaimer: Copyright © 2024 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 = 2852 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 Katie Jordan
Katie Jordan
ASCIISamson Properties
Call Today!: (703) 477-2988

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 = 2852 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;
Brian Scott NMLS#1323665
ASCIIPrimeLending
Call Today!: (540) 336-5090

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App