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

70 Cypress Cove
Delhi, LA 71232
Anna Romero with Cypress State Realty, original listing - (318) 728-4043

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,275,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 6206 Square Feet
Agency: Cypress State Realty
Agency Phone: (318) 728-4043

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2009
Notes: This incredible home was inspired by the architecture of New Orleans for an authentic southern feel. Unique materials were sourced and used throughout construction, including genuine antique brick, cypress beams and timeless heart pine flooring. Home is located on Poverty Point Reservoir and is only a short golf cart ride away from Black Bear Golf Course. Cypress Cove Drive is unique with lake views from the front and the back of this property! Home has over 6200 square feet of living area, with almost 8600 square feet under roof. Property includes: 4 bedrooms, 4.5 bathrooms, custom gunite pool + hot tub, brick walkways, plantation shutters + floor length windows. Gas lanterns light the front porch, copper gutters + patio roof. The first floor is home to the kitchen, primary bedroom suite, living area, study and formal dining room. The gourmet kitchen was built for entertaining, overlooking the back lawn with a perfect view of the pool area, patio and lake sunsets. The kitchen is furnished with high-end appliances, including a stunning copper vent hood over the island. The large laundry room has multiple hookups installed. The second floor hosts three spacious bedrooms, the second living room area and access to a large balcony overlooking the front lawn.Two bedrooms share and Jack and Jill bathroom, and the other bedroom complete with a private bath. Each bedroom has nicely sized custom closets and beautiful views. The third floor includes a gym/game room, heated/ cooled storage and fourth bathroom-complete with a walk in shower and sauna! Exterior amenities include covered brick patio with remote screening- instant insect protection with the click of a button while still enjoying the sunset over the lake. A large garage, exterior storage and extra parking area offer great convenience. This home is truly a once in a lifetime find, ready for new owners to love! Contact your agent to schedule a showing. Pre-approval letter is requested prior to showing appointment.
MlsNumber: --
ListingId: 11279426


Listing Provided By: Cypress State Realty, original listing
Phone: (318) 728-4043
Office Phone: (318) 728-4043
Agent Name: Anna Romero
Disclaimer: Copyright © 2024 My State MLS. 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