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

8637 Saint Marino Boulevard
Orlando, FL 32836

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,950,000
Beds: 5
Baths: 7
Status: Active
SqFt: 4764
Agency: Wemert Group Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2003
Notes: SELLER MOTIVATED!! Live your LAKE VIEW dream overlooking LITTLE SAND LAKE in this stunning COMPLETELY RENOVATED POOL home offering high end finishes and designer touches everywhere you turn, THREE STORIES with an **ELEVATOR** to access each floor, THEATER ROOM, all the UPGRADES & SMART FEATURES you could possibly want, amazing AMENITIES and all with sweeping WATER VIEWS! The gorgeous renovation was completed in 2023 and no detail was missed; ADDITIONAL KITCHEN, whole house RE-PIPE, FRESH PAINT INSIDE & OUT, NEW tankless gas water heater, NEW DOUBLE PANE WINDOWS & SLIDERS, TRAVERTINE pool deck, FOAM WALL INSULATION, SMART HOME features & SPEAKERS throughout, NEW TILE FLOOR with SOUND-PROOF INSULATION throughout, all the way down to the window treatments, light fixtures and so much more! The elevator allows easy access to all three floors giving your family room to grow OR enjoy the benefits of MULTI GENERATIONAL LIVING. A SECOND KITCHENette was added on the first floor in addition to an expansive family room, enjoy the panoramic views of the Lake, walk-out and entertain poolside or pop some popcorn and kick back in your THEATER ROOM, outfitted with a MINI-SPLIT A/C to keep you cool while you watch your favorite movies! Your MAIN LIVING is on the second level making the most out of the amazing view in a light and bright OPEN CONCEPT; combined formal living and dining with a GOURMET KITCHEN perfectly situated in the center of it all making gathering with family and entertaining friends a breeze. The kitchen was thoughtfully designed to be a home chef’s dream with the WATERFALL ISLAND, seemingly endless NEW shaker-style cabinetry for ample storage, NEW stainless steel appliances, breakfast bar seating and beautiful stone counters. Your living and dining are on either side where walls of windows allow the NATURAL LIGHT to pour in and let you enjoy your home with unobstructed views! You'll enjoy viewing Volcano Bay, the Orlando Eye, and Universal fireworks every night! Also on the main floor behind double doors you will find one of TWO PRIMARY SUITES, this one offering access to a private balcony, DUAL WALK-IN CUSTOM CLOSETS and an EN-SUITE BATH ripped from the pages of a magazine. The master bath boasts a NEW SOAKING TUB, DUAL vanities, private water closet/toilet and a DUAL-HEAD shower. You will find the SECOND MASTER suite and an additional bedroom on level one and 2 more secondary bedrooms AND AN OFFICE on level three **EVERY BEDROOM IS AN EN-SUITE with its own bath**! Three different access points to 2 BALCONIES and your covered lanai complete with a NEW SUMMER KITCHEN! The HEATED POOL & SPA area was also given a refresh during the renovation with a NEW FILTER, upgraded pool plumbing and ADDED OUTDOOR SHOWER. Zoned for A-RATED Bay Meadows Elementary this GUARD-GATED COMMUNITY is the epitome of luxury with a 24-HOUR GUARD and convenient access to surrounding lakes, shopping and you are just steps from Dr. Phillips’ RESTAURANT ROW, minutes from world renowned THEME PARKS and everything else Central Florida has to offer! LUXURY LAKEFRONT LIVING is waiting for you on Saint Marino Blvd - call today to schedule your private tour!
MlsNumber: O6163262


Listing Provided By: Wemert Group Realty, original listing
Name: Wemert Group Realty
Phone: (407) 412-8488
Office Name: WEMERT GROUP REALTY LLC
Office Phone: (407) 412-8488
Agent Name: Jenny Wemert
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.


Local Real Estate Expert

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 = 3351 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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;
Real Estate Expert Photo for Kristi Rujano
Kristi Rujano
ASCIIOrlando Regional Realty
Mobile: (407) 405-5574

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App