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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

136 N Buena Vista Avenue
Orlando, FL 32835

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $339,967
Beds: 3
Baths: 2
Status: Active
SqFt: 1068
Agency: US Realty Hub, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1986
Notes: THE WARRANTY ON THIS HOME! Welcome to your dream home! This stunning property boasts a one-year contractor transferable warranty on a full remodel, offering you peace of mind and assurance. With no HOA or deed restrictions, you have the freedom to make this home truly your own.<br /> <br /> Step inside to discover a new re-pipe with a 5-year warranty, ensuring the plumbing is in top-notch condition. The fenced yard provides privacy and security, perfect for pets or outdoor gatherings.<br /> <br /> Built for comfort and convenience, this home features a newer roof from 2020 and a newer AC unit, ensuring energy efficiency and comfort year-round. The 3 bedrooms and 2 bathrooms are laid out in a split plan, all on one floor with no stairs, making it ideal for any lifestyle.<br /> <br /> The spacious front yard and long driveway offer plenty of space for parking and play. Additionally, this property offers RV, boat, trailer, or equipment parking without HOA restrictions, providing ample space for all your vehicles and toys.<br /> <br /> Inside, you'll find an open floor plan with quartz countertops and solid wood cabinets in the kitchen, perfect for entertaining guests. The highlight of this home is the huge master bedroom suite with an in-suite master bath, providing a private oasis for relaxation. Step outside to enjoy the large patio, enclosed and fenced for added privacy with a screened gazebo.<br /> <br /> The property is adorned with fruit trees and energy-saving shade from mature trees, creating a serene and eco-friendly environment. With a low water bill due to the septic tank, you'll enjoy savings year after year.<br /> <br /> Located just minutes from 408, downtown, near a bus line, Valencia College, and Universal Studios, this home offers convenience and accessibility to all that Orlando has to offer.<br /> <br /> Don't miss this opportunity to own a piece of paradise!<br /> <br /> *Disclaimer: Pictures were digitally enhanced. It is the responsibility of the buyer, brokers, and agents to check all the information listed on this ad via due diligence and do their own verification of what is listed on this add.
MlsNumber: O6180122


Listing Provided By: US Realty Hub, LLC, original listing
Name: US Realty Hub, LLC
Phone: (407) 900-1001
Office Name: REALTY HUB
Office Phone: (407) 900-1001
Agent Name: Veronica Read
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