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 = 358 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 = 358 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 = 358 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;

1621 Yellow Brick Road
Astor, FL 32102
Jodi Molzof with Engel & Völkers Ocala, original listing - (352) 820-4770

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $850,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2951 Square Feet
Agency: Engel & Völkers Ocala
Agency Phone: (352) 820-4770

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 27,878 sqft
Property Type: Other-Single Family Residence
Year Built: 2006
Notes: One or more photo(s) has been virtually staged. Can't find your way home? Just follow the Yellow Brick Road! This stunning, custom-built riverfront retreat is every boater's dream. Perfectly positioned on a deep, fresh water canal leading to the St. Johns River, with easy access to the Intracoastal Waterway, this unique property offers the best of Florida living. This 3-bedroom, 2.5-bathroom home, including an office, spans 2,951 Sq Ft of luxurious living space, AND sits on a double lot (.64 acres). The home is packed with thoughtful, high-end upgrades and features that make it a true gem. NEW metal roof (2023), NEW AC (2022), tankless hot water heater (gas), reverse osmosis water treatment system, roll-down hurricane shutters, central vacuum and energy-efficient upgrades throughout. Boasting a custom chef's kitchen with built-in features including a 42" refrigerator, gas stovetop with high-volume hood, and a convenient sliding kitchen window with a pass-through to the Florida room bar top. Enjoy cozy nights in the family room with a ventless gas fireplace and built-in entertainment center. Venture outdoors to your 1500 Sq Ft dock, complete with TV, surround sound stereo, full kitchen with sink, refrigerator, grill, and hot water heater. Also featured is a 50-amp service and a boat lift with 2 motors (7500 lb). Adjacent to the home is a spacious 30X50 RV/carport with 15-ft clearance for a Class-A RV (50-amp service included), along with an 8X12 utility room complete with a workbench for all of your projects. The sitting area next to the carport is perfect for nights by the firepit with gorgeous water views. But wait, it doesn't end there! This home also features a 12,500 KV whole-home generator, irrigation system using river-water, and roof gutters that drain to the river. This meticulously cared-for residence leaves no stone un-turned for its next owner. Bring your friends, family, boats and RVs- and experience the Florida lifestyle in its finest form! Schedule a private tour today and see why this home is the perfect fit for you!
MlsNumber: --
ListingId: OM694803


Listing Provided By: Engel & Völkers Ocala, original listing
Phone: (352) 820-4770
Office Phone: (352) 820-4770
Agent Name: Jodi Molzof
Disclaimer: Copyright © 2025 Engel & Völkers. 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 = 358 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 Alan Bird - "A man of His Word."  Broker Associate/Realtor GRI, ABR
Alan Bird - "A man of His Word." Broker Associate/Realtor GRI, ABR
ASCIIThe Real Estate Firm of Orlando
Call Today!: (407) 432-8303

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App