meta_query='key:subdist__c;value:Ingleside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='378177' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12158
[post_author] => 4
[post_date] => 2018-10-29 01:19:09
[post_date_gmt] => 2018-10-29 01:19:09
[post_content] => Ingleside is a lot more down-to-earth than some of its swankier neighbors on the north end of town, and it's also a lot more affordable. Homes tend to be modest, some in the same family for generations. Unexpected views of downtown add to the attraction of this more-affordable neighborhood, which also has great public transit options and easy freeway access.
[post_title] => Ingleside
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => ingleside
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 11:47:15
[post_modified_gmt] => 2024-04-09 18:47:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12158
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
_yoast_indexnow_last_ping, 1716425833
ffd_listing_title, 608 Lakeview Avenue, San Francisco, CA, 94112
ffd_mls_id, 424025196
ffd_salesforce_id, a0EUd000001mSWAMA2
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 608 Lakeview Avenue, San Francisco, CA, 94112
pba__address_pb__c, 608 Lakeview Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Offers Due May 1st by 9am. Disclosures available here: https://app.disclosures.io/link/608-Lake-Street-p5jqsyrr Please contact Dana Cohen at 415-305-3539 for all showing requests. Please email [email protected] for disclosures, questions, and offer information. Sellers and Agents do not warrant square footage or bedroom count. Included in the 1,295 sqft. estimate is 379 sqft of improved space and 2nd bathroom that was designed to code per sellers, but completed without permit in June 2020. Buyers to investigate all information provided, including square footage, to their own satisfaction. All buyers to use the most current 8-page SFAR contract. Escrow open with Heather Shiffer @ First American Title.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1949
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-04-19T00:48:27.000+0000
days_on_market__c, 34
dom__c, 13
ffd_description_pb, Perched atop Ingleside, this beautifully updated home enjoys sweeping views from the Pacific Ocean and the Farallon Islands to Sutro Tower and the San Francisco Bay. The spacious eat-in kitchen has been beautifully and conveniently updated with a full suite of stainless steel appliances, including an LG refrigerator, Bosch dishwasher, gas range, and microwave. The living room is the perfect place to entertain and relax while enjoying the stunning views of the city, the bay, and the massive backyard. The home's main level is completed by 2 amply proportioned and sunlight-filled bedrooms, each with large closets, and an attractive bathroom with shower over tub and modern fixtures. Light fixtures throughout have been stylishly updated. The owners thoughtfully designed and built out the lower level during the pandemic into a multi-functional and flexible bonus room with an additional bathroom. This space opens directly out to the immense backyard on two levels with planting beds, flowering trees, and great potential. The 1-car garage has plenty of room for storage and a stacked LG washer/dryer. Superbly located a few blocks from Ocean Ave shops, restaurants, and cafes, including Philz Coffee and Whole Foods, the home is a commuter's dream with easy access to BART, Muni, and highways.
district__c, SF District 3
entry_level__c, 0
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-05-23T00:54:46.000+0000
pba__latitude_pb__c, 37.7183625
pba__latitude_property__c, 37.7183625
laundry_features__c, In Garage;Washer/Dryer Stacked Included
listed_date__c, 2024-04-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Priya
pba__listing_agent_lastname__c, Agrawal
listing_agent_mls_id__c, 810564
ffd_listingagentname, Priya Agrawal
listing_agent_number__c, 1047032
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, RIVET
listing_office_name__c, Rivet Real Estate
listing_office_number__c, 28789
pba__listingprice_pb__c, 1075000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.608lakeview.com
pba__longitude_pb__c, -122.4564629
mls_id__c, 424025196
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-04-18
original_price__c, 1075000
overall_days_on_market__c, -81922
parking_access__c, Independent
parking_features__c, Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2024-05-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-05-22T11:29:41.000+0000
price_per_square_foot__c, 1004.63
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001mSWAMA2
sale_date__c, 2024-05-22
sale_price__c, 1301000
selling_agent_mls_id__c, MLSL5089626
selling_agent_number__c, 981374473
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Real Estate Experts
pba__status__c, Closed
pba__totalarea_pb__c, 1295
size__c, 1295
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Lakeview
subdist__c, Ingleside
ffd_name, 608 Lakeview Avenue, San Francisco, CA, 94112
view__c, Ocean;City;Panoramic;City Lights;Bay;San Francisco;Twin Peaks;Hills;Mountains;Sutro Tower
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1949
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530763724-1.jpg