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

926 Old St Johns Road
Irvington, VA 22480

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $459,500
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1710 Square Feet
Agency: Shaheen,Ruth, Martin & Fonville Real Estate
Agency Phone: (804) 288-2100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Take refuge at this comfortably stylish home located in the delightful community of Hills Quarters in Irvington. Quaint covered porch welcomes you to this 1710 sq ft home with spacious Living Room with vaulted/cathedral ceiling open to Dining & generous Kitchen for entertaining family and friends. Newly built in 2023 with numerous upgrades of kitchen appliances, luxury vinyl plank flooring, wood cabinetry with granite counters, additional recessed lighting & tiled bathrooms. Relax in this ideal 3 Bedroom, 2 full Bathroom retreat while enjoying this charming community just minutes to Kilmarnock & Irvington. Primary Bedroom Suite with ensuite bath with double vanity, step-over shower, & walk-in closet. Venture to your full front or rear porch for an immersive experience of small-town charm in an ideal neighborhood with clubhouse for community activities or private parties, swimming pool, tennis, pickle & basketball courts, children's play area and walking trails. Homeowners Association fees include amenities of public water and sewer plus yard maintenance, trimming & mulching, trash collection and underground utilities including internet. Convenient 2 car garage with paved driveway for ample parking. Convenient attic access in garage. Potential for buyer to add mini split/HVAC in garage for extra space as family or playroom. Close proximity to Main Street Kilmarnock with restaurants, shopping & parks; this is the ideal weekend retreat or full-time home. Small Town, Big Charm! Here every day feels like an Escape! So drift away right at Home!
MlsNumber: --
ListingId: 118019


Listing Provided By: Shaheen,Ruth, Martin & Fonville Real Estate, original listing
Phone: (804) 512-2086
Office Phone: (804) 288-2100
Agent Name: Travis Powell
Disclaimer: Copyright © 2024 Northern Neck Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App