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

607 Blue Heron Drive
Upper Lake, CA 95485
Sheryle McNamara with Luxe Places International Realty, original listing - (707) 462-1600

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,750,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 20500 Square Feet
Agency: Luxe Places International Realty
Agency Phone: (707) 462-1600

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential Multi Family-Apartment
Year Built: 1992
Notes: Owner has Beautifully maintained Blue Heron Gardens with excellent on-site management--continuously upgrading during his 25 years of operation. There are many long-term tenants, plus an historically low vacancy and turnover rate. Tenants appreciate having a coin operated laundry room on-site, and a large park-like exterior common area that includes picnic tables and BBQ. There are 21 2BR 1.5 Bath two-story Townhouses, and 4 1BR 1 Bath flats--with the upstairs featuring private exterior balconies. Each of the 25 Units have their own carport with plenty of additional parking. There are 5 buildings on 5 separate legal lots set up as 3 Fourplexes, one 5 Unit, & one 8 Unit bldg. "Actual" Cap Rate of +-5.5 includes "Actual Rents" with June 1, 2024 rent increases. An added "perk" (in addition to being a quality investment) is that Blue Heron Gardens is located in Lake County, CA--known to be an "outdoor paradise." For an investor from out of town, site visits would be something to look forward to! Across the street is the beautiful and expansive Clear Lake with over 68 square miles--which is CA's largest freshwater Lake. (Tahoe's larger but shared by NV). There are PICTURESQUE views, excellent restaurants, plentiful parks, and walking and hiking trails to enjoy--plus activities to watch or participate in such as camping, fishing, boating, skiing, swimming & kayaking. It is said that Clear Lake is "one of the top spots in the U.S. for fishing." It is also known as "The Bass Capital of the West," and has famous highly competitive local and national fishing tournaments held often--in fact, 93 remain to be held this year (per CA Fish & Wildlife). Water birds are plentiful too--including egrets, swans, BLUE HERONS, & pelicans plus Eagles are commonly seen. Bordering Napa County, Lake County is known for vineyards also--with over 9,000 acres planted, & over 30 "world class wineries" to visit. Upper Lake is just 30 miles East of Ukiah, 75 miles North of Santa Rosa & Napa, and 125 miles North of San Francisco and Sacramento.
MlsNumber: --
ListingId: LC24063279


Listing Provided By: Luxe Places International Realty, original listing
Phone: (707) 462-1600
Office Phone: (707) 462-1600
Agent Name: Sheryle McNamara
Disclaimer: Copyright © 2024 Lake County Association of REALTORS®. 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 = 199 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;
Real Estate Expert Photo for Baldo Tamayo
Baldo Tamayo
ASCIIRemax Gold Lakeport
Call Today!: (707) 295-8267

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App