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

274 Lakay Place
Longwood, FL 32779

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $925,000
Beds: 5
Baths: 5
Status: Active
SqFt: 3612
Agency: Orlando North Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2005
Notes: Welcome Home to your dream home in gated Terra Oaks, meticulously & lovingly maintained by these proud original owners. This custom-built home was professionally decorated with the very best of everything, and the quality is evident throughout. In addition to the BRAND NEW ROOF (with 10-year transferrable workmanship warranty), Smart features & app-driven bells 'n whistles, upgraded 5-ton A/C w/ 10-year warranty 'til 2029, transferrable Termite Bond, newer exterior paint, upgraded landscape & hardscape, you'll enjoy the inviting backyard with new paved firepit area with unique removable grilling feature. The screened pool and shaded lanai will be your favorite spot for entertaining, especially with the awesome speaker system outside!! The majority of the living space in this spectacular home is on the main level while the Bonus Room (which could double as the fifth bedroom suite) is located upstairs. Upon entering, you'll immediately get a million-dollar view of the pool through the Living Room, which is adjacent to the elegant Dining Room. The Kitchen is equipped and designed for the CHEF in you, with solid wood cabinetry, sleek Island, built-in dual ovens, stainless steel appliances and a bright dinette space. The Kitchen overlooks the casually elegant Family Room, with gas fireplace, and fabulous views of the lush backyard and pool. The Owner's Primary Suite will be your private retreat, located away from the secondary bedrooms in this enviable split bedroom plan. The grand space offered in this suite includes a separate sitting area, trey ceiling with recessed lighting and access to the pool & lanai. Expect to be impressed when you see the luxurious bathroom with large soaking tub, separate tiled shower, dual vanities and private water closet. Just steps from the Owners' Suite is the dedicated Office with wood flooring, just across from a full bathroom with access to the pool & lanai. The three secondary bedrooms are on the opposite side of the home, along with two additional full bathrooms. Terra Oaks is a gated enclave located just minutes from Lake Brantley High School, along with the upscale shops & restaurants located conveniently to this property, along the SR434 corridor, which is also just minutes from your commute to I-4. This home also has quick access to Wekiva Springs State Park and Wekiva Island for some "Olde Florida" recreation and kayaking on the Wekiva River. Properties this beautifully appointed do not come along very often, and especially not in the pristine condition of this fine home. You'll want to get in quickly, before it's GONE!
MlsNumber: O6196845


Listing Provided By: Orlando North Realty, original listing
Name: Orlando North Realty
Phone: (407) 862-9700
Office Name: KELLER WILLIAMS HERITAGE REALTY
Office Phone: (407) 862-9700
Agent Name: Kristin Mazza
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 = 382 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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;
Diane Sterling
ASCIIKeller Williams Realty Advantage
Call Today!: (407) 761-0512

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App