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;

1 Calle Sunset
Aguadilla, Aguadilla, PR 00603

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $825,000
Beds: 6
Baths: Full: 5
Status: Active
SqFt: 3334 Square Feet
Agency: F. L. Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: Contact us for a link to a video tour. Beautifully designed hillside home with 3 units in the Playuela area of Aguadilla. Panoramic and ocean views from this immaculate and modern home. Just 4 minutes (less than 1 mile) from Playa Pena Blanca, which is one of the most beautiful beaches in Puerto Rico. The whole home is in immaculate condition and is move in ready. It has a Tesla solar system and batteries as well as a transfer switch for a conventional generator. There is a 4 bedroom main unit as well as 2 additional 1 bedroom units. The main unit of this home occupies the top 2 floors. It is accessed by a driveway with an electric gate, or also from below by a stair case. It has a small private yard, and a carport. This unit is spacious, with 4 bedrooms, 3 bathrooms and 2 ocean view terraces. The lower level has 1 bedroom (currently used as an office), 1 full bathroom, modern kitchen, dining room, 2 living rooms (1 of which can easily be converted to a 5th bedroom), and a laundry room. A door from the living room opens onto a large covered terrace with expansive views. The upper level features 3 more bedrooms and 2 bathrooms. The master suite is fantastic and includes a huge bathroom with a double shower, a roomy walk in closet and a sitting area with doors onto a private ocean view balcony. The main unit is sold with appliances. The lower 2 levels have one apartment each. The lowest level is a large studio unit with bathroom and a balcony. This apartment has a creatively designed frame around the bedroom with electric shades that roll up or down to enclose the bed space, give privacy and block light. The second level is a 1 bedroom, 1 bathroom apartment. This unit has extra high ceilings, lots of space and a traditional bedroom with a door. It also has a large partially covered private terrace with ocean view. Both of the units have full kitchens, are updated with a modern design and are stylishly decorated. They are in immaculate condition and suitable for either AirBnB or long term rentals. Both apartments are being sold fully furnished, have air conditioners and security doors and windows. A side yard is located at the lower level, with an incomplete concrete structure. This area would offer space to add a small swimming pool. This house is beautiful, unique, in a privileged location and offers income potential. Less than 10 minutes from the Aguadilla airport and only minutes to shopping, schools, restaurants and nightlife. Other nearby beaches include Crashboat, Borinquen, Wilderness, and Surfer's. Jobos is only 15 minutes away and Rincon only half an hour..
MlsNumber: --


Listing Provided By: F. L. Realty, original listing
Phone: (787) 466-6749
Office Phone: (787) 466-6749
Agent Name: Francisco Lopez
Disclaimer: Copyright © 2024 Xposure MLS Puerto Rico. 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