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

1213 Walthall Creek Drive
South Chesterfield, VA 23834

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $545,000
Beds: 5
Baths: 4
Status: Pending
SqFt: 3585
Agency: Refine Properties, LLC.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2005
Notes: IMMACULATE, MOVE-IN READY! This Colonial exterior with an amazing Full Front Porch and Balcony SURPRISES with an open TRANSITIONAL Floor Plan and CONTEMPORARY features! Upon entering, a 2-Story Foyer with a stunning split Staircase, a gorgeous contemporary Chandelier, Palladian Window and Hardwood Floors greets! To the right, a Living Room, perfect for an Office, boasts Hardwood Floors, Recessed Lights, Built-In Ceiling Speakers, and Crown Molding. To the left, the open Dining Room showcases a unique Chandelier, Hardwood Floors, Built-In Ceiling Speakers, Picture Frame and Crown Molding. Ahead, the Spectacular 2-Story Family Room WOWS featuring a Wall-of-Windows, upstairs Balcony Overlook, Recessed Lights, Gas log Fireplace w/Stone Surround, and Built-In Speakers. The extraordinary kitchen boasts upgraded 42-inch Cabinets, Hardwood Floors, Granite Countertops, Ceramic Backsplash, Recessed and Pendent Lights, a contemporary Ceiling Fan, and Stainless Appliances with a Double-Oven Stove! The Breakfast Room amazes with a Vaulted Ceiling, Wall-of-Windows, Transoms, and a unique, modern Light Fixture. Continuing down the hall is a perfect First-Floor Bedroom with access to a Full Bath for in-laws or guests. Ready to go Upstairs? A huge Primary Bedroom Ensuite awaits featuring a Vaulted Tray Ceiling, Recessed Lights and ample storage with 4 Closets! The Bathroom provides a dream Spa Retreat with a shower panel with 6 Body Jets, and Soaking Tub. Down the hall are 3 additional spacious Bedrooms with 2 having direct access to the Balcony to relax. Need more space? The 3rd Floor offers a Spacious Bonus Room/6th Bedroom Suite with a Full Bath. Before leaving, head out back. Enjoy hosting Cookouts on the expansive Deck with Built-In Benches. And don't miss the amazing Stone Firepit area where you can sit around roasting marshmallows on a crisp Autumn and Winter Day. Additional Upgrades are Granite Countertops on all Bath Vanities, Whole-Yard Irrigation, and a Security System.
MlsNumber: 2408039


Listing Provided By: Refine Properties, LLC., original listing
Name: Refine Properties, LLC.
Phone: (804) 339-5700
Office Name: reFine Properties
Office Phone: (804) 339-5700
Agent Name: Sharon Stewart Murphy
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.


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 = 2845 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 Toni Hill-Lucas
Toni Hill-Lucas
ASCIIPlentura Realty LLC
Call Today: (804) 255-7374

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App