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

Calle Betances Calle Betances
San Sebastian, PR 00685

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $339,000
Beds: --
Baths: --
Status: Active
SqFt: 6000
Agency: HECTOR BAEZ REAL ESTATE

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: MultiFamily
Year Built: 1950
Notes: Real Estate Investment in San Sebastián Introducing a remarkable property in a prime location, nestled next to the historic City Hall, the iconic San Sebastián Mártir Parish, and the lively Town Square - the true heart of San Sebastián’s downtown area. We present a unique real estate opportunity with approximately 1000 square meters of land and 6000 square feet of versatile construction. This includes 3 operational commercial spaces, 1 luxury residence, and a spacious basement. Tailored for visionary investors, the Commercial Property hosts three active businesses on the ground floor, while the upper floor boasts a high-end residence complete with all modern amenities, including a private balcony. Moreover, the property possesses potential for expansion on the second level, allowing for the addition of residential or commercial spaces at the buyer’s discretion. The rear area of the property holds significant potential for the creation of private parking or the development of new residential or commercial projects, presenting an excellent business opportunity. The residence embodies elegance and comfort, with terrazzo floors, four cozy bedrooms, a spacious living area, a dining room perfect for hosting celebrations, a fully-equipped kitchen, a full bathroom, a guest restroom, a balcony, and a terrace for outdoor enjoyment. Situated in a historically significant area, surrounded by income-generating properties, this investment stands out as an exceptional value in the real estate market. Its proximity to educational institutions, healthcare centers, religious sites, professional and government offices, as well as the thriving local commerce, adds significant value to this unique investment opportunity. A large backyard borders a public parking area, further enhancing its appeal and functionality.
MlsNumber: PR9105277


Listing Provided By: HECTOR BAEZ REAL ESTATE, original listing
Name: HECTOR BAEZ REAL ESTATE
Phone: (787) 236-9560
Office Name: HECTOR BAEZ REAL ESTATE
Office Phone: (787) 236-9560
Agent Name: Hector Baez
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