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

151 Rippling Waters Way
Falling Waters, WV 25419
Jamie Lopez with ERA Liberty Realty, original listing - (304) 728-2000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $629,900
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 5585 Square Feet
Agency: ERA Liberty Realty
Agency Phone: (304) 728-2000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: Imagine living in a truly unique and one-of-a-kind, 5585sqft colonial masterpiece! This splendid home, thoughtfully outfitted by its owner, a skilled commercial general contractor, is a dream come true. <br /> <br /> Step into a brand-new, high-quality custom kitchen, complete with stunning quartz granite countertops. <br /> <br /> Enjoy your mornings in the charming morning room with its elegant coffered ceiling, or gather in the spacious two-story family room featuring indirect lighting, a beamed ceiling, and a beautiful two-story brick-faced fireplace. <br /> <br /> The dining room boasts a lovely cove tray ceiling adorned with custom lighting, setting the perfect tone for memorable meals. <br /> <br /> You'll be captivated by the Swarovski crystal chandeliers gracing both the sitting room of the master bedroom and the foyer. <br /> <br /> The entire first and second floors shine with gorgeous hardwood flooring and are illuminated by energy-efficient LED recessed lighting. <br /> <br /> There are 2 permanently installed LCD TV's in a recessed manner to be flush to the wall behind one way mirrors with picture frames. Can be scrolling art works in addition to usable TV's.<br /> <br /> For your peace of mind, a security system is also in place. The half bath has a double trey ceiling.<br /> <br /> Convenience is key, with a laundry room and office located on the first floor and a dual staircase from the foyer and the kitchen.<br /> <br /> The second-floor bedrooms two and three share a delightful Jack and Jill bathroom featuring new ceramic floors, while the second master on this level offers its own private full bathroom. The 2nd story overlook to the family room is breathtaking.<br /> <br /> The master bedroom is a true sanctuary, complete with cathedral ceilings, a cozy sitting room adorned with a Swarovski crystal chandelier, and a marble-surrounded fireplace. The luxurious master bathroom features a grand double door entrance, a jetted garden tub, a separate shower stall, a water closet, and two additional closets for all your storage needs. Plus, there’s a custom walk-in closet in the master bedroom and a laundry chute to the laundry room. <br /> <br /> Venture down to the basement, where you'll find a fantastic game room, a home theater, a dedicated home gym, a full bathroom, and a storage room full of steel shelves. <br /> <br /> The walkout basement leads to a lovely stone patio, perfect for outdoor relaxation. <br /> <br /> The oversized garage and newly sealed driveway add even more charm to this exceptional property. <br /> <br /> As a bonus, the subdivision offers homeowner access to a private Potomac Riverside park, complete with a boat launch, gazebo, and plenty of open space for family fun and playtime. This is not just a home; it's a remarkable lifestyle waiting for you in an amazing neighborhood!
MlsNumber: --
ListingId: WVBE2037116


Listing Provided By: ERA Liberty Realty, original listing
Phone: (304) 728-2000
Office Phone: (304) 728-2000
Agent Name: Jamie Lopez
Disclaimer: Copyright © 2025 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 = 2968 AND i.igate IN ('usahud','orhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'orhud', 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

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 = 2968 AND i.igate IN ('usahud','orhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'orhud', 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 Ashley Burch NMLS#2527054
Ashley Burch NMLS#2527054
ASCIICapital First Mortgage, L.L.C.
Call Today!: (304) 283-0575

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App