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

111 La Paloma
Del Rio, TX 78840

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $485,000
Beds: 4
Baths: 4
Status: Active
SqFt: 2780
Agency: Lake Amistad Realty LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2014
Notes: Welcome to your dream home nestled in the serene community of La Caleta, just moments away from the picturesque Amistad Lake. This upscale residence boasts luxurious amenities and a tranquil ambiance, offering the perfect blend of comfort and sophistication. Step through the inviting front doors and into a world of elegance and style. The open-concept floor plan, adorned with high ceilings and abundant natural light, creates a welcoming atmosphere throughout the home. The main level features a formal dining room, perfect for hosting intimate gatherings, and an inviting living room ideal for relaxation or entertaining guests. The chef's kitchen is a culinary masterpiece, equipped with high-end fixtures and finishes, providing the perfect setting for culinary creativity. The split floor plan ensures privacy and convenience, with the grand master en-suite offering a luxurious retreat. Pamper yourself in the opulent bath, complete with a jetted tub and separate tall shower, designed for ultimate relaxation and rejuvenation. Entertainment is effortless in this home, with a built-in media/playroom providing endless possibilities for recreation and leisure. Step outside to discover the stunning outdoor living space, complete with an outdoor kitchen and a sparkling in-ground pool, perfect for enjoying the warm Texas weather and creating memories with family and friends. Additional Features: High-End Fixtures and Finishes Bonus Room/Media/Play Room Outdoor Kitchen In-Ground Pool Ample Storage Space Landscaped Yard Two-Car Garage Experience luxury living at its finest in this gorgeous upscale home in the heart of Del Rio's La Caleta community. Don't miss the opportunity to make 111 La Paloma your forever home. Schedule your private viewing today!
MlsNumber: 205250


Listing Provided By: Lake Amistad Realty LLC, original listing
Name: Lake Amistad Realty LLC
Phone: (830) 774-0371
Office Name: eXp Realty, LLC-Legacy Realty Group
Office Phone: (830) 774-0371
Agent Name: CLAY SEWALT
Disclaimer: Copyright © 2024 Del Rio Board of Realtors. 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