Title Page Background
DEBUG FN args: Array ( [0] => 2306 [1] => [2] => [3] => agent ) BEFORE: Site: 2306 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2306 Igate: njhud LocID: 2306 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2306 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2306 [1] => [2] => [3] => lender ) BEFORE: Site: 2306 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2306 Igate: njhud LocID: 2306 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2306 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2306 [1] => [2] => [3] => other ) BEFORE: Site: 2306 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2306 Igate: njhud LocID: 2306 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2306 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

Marfil St. Tesoro Del Mar In Las Palmas
Hatillo, PR 00659

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $5,750,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 2897 Square Feet
Agency: CARIBBEAN REALTY
Agency Phone: (787) 269-1010

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1998
Notes: Welcome to Tesoro del Mar – a hidden gem that boasts unrivaled privacy, direct beach access, and breathtaking ocean views. Frequented by top celebrities, this property is tailor-made for discerning buyers seeking a slice of paradise. Not only does it offer a unique retreat, but it also comes with a growing, successful short-term rental and event venue business that has already proven to generate outstanding revenue numbers. The well-established business is ready for its new owner, promising a seamless transition and continued success.<br /> <br /> Tesoro del Mar accommodates up to 15 guests, offering an intimate getaway from the tourist crowds. Imagine waking up to the soothing sound of waves lapping the shore and enjoying panoramic views of the sea from every corner of the property. The residence is fully furnished in a monogram minimalistic style, ensuring luxury and comfort for all guests. What sets Tesoro del Mar apart is its seclusion, with no neighboring properties to disturb your peace. This privacy, combined with facilities such as a pool and water heater, ensures a tranquil and exclusive experience.<br /> <br /> For those concerned about sustainability and self-sufficiency, Tesoro del Mar is equipped with a 20Kw generator and a 1,000-gallon water tank, ensuring uninterrupted comfort and convenience. The property also includes a business social media page with more than 70,000 followers, offering a solid platform for marketing and business growth. This comprehensive package not only ensures operational readiness but also a strong online presence from day one.<br /> <br /> Investors will find Tesoro del Mar to be a golden opportunity. Its prime beachfront location, coupled with the luxury and privacy it offers, makes it a highly desirable vacation rental property or a perfect place for weddings and events. The sale includes a land lot used for parking that can fit 60 cars, as well as bookings for 2024-2025, ensuring immediate revenue potential. The entire business strategy currently being used is part of the package, offering insight into the property's successful operation and potential for lucrative returns.
MlsNumber: --
ListingId: PR9104992


Listing Provided By: CARIBBEAN REALTY, original listing
Phone: (787) 377-1856
Office Phone: (787) 269-1010
Agent Name: Edwin Cordero
Disclaimer: Copyright © 2024 Stellar 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