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

74 Colorado Court
Scroggins, TX 75480
Nicole Anderson with Ramsey Group- Lake Cypress, original listing - (903) 767-2805

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,995,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 3333 Square Feet
Agency: Ramsey Group- Lake Cypress
Agency Phone: (903) 767-2805

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1993
Notes: Experience unparalleled lakeside living with this stunning waterfront home on Lake Cypress Springs, nestled in the coveted Pine Valley Subdivision. Offering some of the most breathtaking views on the lake, this 4 bedroom, 3.5 bathroom home is a perfect blend of luxury and comfort. Below the home you will find a fully private 1 bedroom, 1 bath guest suite providing additional space for friends and family. The recently remodeled kitchen is a chef’s dream, complete with state of the art appliances, granite countertops, and expansive views of the lake, making it the ideal setting for entertaining. The living room features a striking wall of windows, flooding the space with natural light and offering panoramic lake views. The master suite is a private retreat, featuring a cozy seating area, a beautifully updated en-suite bath, and serene views to wake up to each morning. Perfect for children or teens, the bunk room offers a fun escape with its own full bath. Every inch of the outdoor space has been designed for relaxation and enjoyment. The expansive decks, made from durable Trex composite decking, offer plenty of space for outdoor gatherings. The gorgeous stone fire pit is ideal for cool evenings, surrounded by lush landscaping that adds to the home’s charm. A private basketball court and detached garage space provide additional recreation and storage options. The standout feature is the incredible boathouse, which includes a party deck, four boat slips, and a boathouse room, perfect for days spent on the water. The property also includes an interior lot, giving you extra space and privacy. Residents of Pine Valley enjoy access to a wealth of amenities, including a gated entrance, community pool, sports court, playground, and more. As a huge bonus, this exquisite home is being sold fully furnished, making it move in ready for your lakeside retreat. Don’t miss the opportunity to own this dream waterfront property!
MlsNumber: --
ListingId: 20758367


Listing Provided By: Ramsey Group- Lake Cypress, original listing
Phone: (903) 767-2805
Office Phone: (903) 767-2805
Agent Name: Nicole Anderson
Disclaimer: Copyright © 2024 North Texas Real Estate Information Systems, Inc. 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