Title Page Background
DEBUG FN args: Array ( [0] => 2896 [1] => [2] => [3] => agent ) BEFORE: Site: 2896 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2896 Igate: njhud LocID: 2896 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2896 AND i.igate IN ('vahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2896 [1] => [2] => [3] => lender ) BEFORE: Site: 2896 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2896 Igate: njhud LocID: 2896 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2896 AND i.igate IN ('vahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2896 [1] => [2] => [3] => other ) BEFORE: Site: 2896 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2896 Igate: njhud LocID: 2896 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2896 AND i.igate IN ('vahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

2051 Valley Spring Court
Powhatan, VA 23139

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $749,500
Beds: 4
Baths:
Status: Active
SqFt: 3118 Square Feet
Agency: Napier REALTORS ERA

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Refrigerator, Garbage Disposer
Architectural Style: Other
Construction Materials: Brick, Vinyl Siding, Frame, Brick Veneer
Cooling: Heat Pumps
Flooring: Carpet, Tile, Wood, Tile - Ceramic
Heating: Heat Pump, Zoned, Fireplace
Interior Features: Ceiling Fans, Fireplace, Cable Tv, Pantry, Solid Surface Counters, Eatin Kitchen, Bedroomon Main Level, High Ceilings, Recessed Lighting, Double Vanity, Walk In Closets
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Kitchen, Laundry, Family Room, Living Room
Utilities: Cable Available

Window Features

Exterior Features: Level, Deck, Landscaped, Paved Driveway, Play Structure
Parking Features: Garage, Paved or Surfaced, Driveway
Patio and Porch Features: Deck

Neighborhood/Schools

Elementary School/District: Flat Rock
Middle/Junior High School/District:
High School/District: Powhatan
Subvidision Name: Valley Springs

Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1997
Notes: Valley Springs in Powhatan is only 8 Miles to Rt. 288 off Huguenot Trail and Judes Ferry Road. Brick front two story with large 1st floor primary bedroom with oversized tile bath and walk in custom closet. The living areas have a living room with gas FP overlooking the decking and huge inground pool and fun kid playground. There is an updated kitchen with solid surface tops, a breakfast area, a 5 burner gas cooktop in island and the kitchen overlooks a vaulted ceiling family room with gas FP, hardwood floors speakers for surround sound and door to decking. GE Profile double door refrigerator with bottom freezer, wall oven and microwave. Lot of cabinets throughout the kitchen, a new tile backsplash and a breakfast area with bay walk out window. The laundry room has cabinets, an on demand gas hot water heater, hookups for washer/dryer and a huge walk in pantry. You will find a 2nd primary suite with full bath and two additional bedrooms on the 2nd floor. Hardwood and tile floors on the first floor. All room have ceiling fans and the home has been freshly painted. A garage with storage area as you walk out of the pantry and partitioned off for entrance from man door and main area. This home has been remodeled and updated with the latest styles. The deck is low maintenance and has an area for a hot tub if one desires off to the side. There is an area for grilling with siding of cement to avoid the vinyl siding being damaged. Gutters and downspouts and extra parking area. Ring spot lights and doorbell. Easy access to Huguenot Trail, Route 60, schools and central Powhatan.
MlsNumber: --


Listing Provided By: Napier REALTORS ERA, original listing
Phone: (804) 794-4531
Office Phone: (804) 794-4531
Agent Name: Lummie Jones
Disclaimer: Copyright © 2024 Central Virginia Regional Multiple Listing Service. 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