meta_query='key:subdist__c;value:Outer Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='235148' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70685
[post_author] => 4
[post_date] => 2018-11-30 20:41:46
[post_date_gmt] => 2018-11-30 20:41:46
[post_content] => Inner Daly City? The curves of I-280 define this skinny stretch of streets that are more connected to the shops of Daly City, with the Daly City BART stop just a few blocks from homes on the south end of the neighborhood. I-280 might have pushed you into Daly City's arms, but we still love and tax you like our own.
[post_title] => Outer Mission
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => outer-mission
[to_ping] =>
[pinged] =>
[post_modified] => 2018-11-30 20:41:46
[post_modified_gmt] => 2018-11-30 20:41:46
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70685
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 737 Huron Avenue, San Francisco, CA, 94112
ffd_mls_id, 422635401
ffd_salesforce_id, a0E8W00000Vtla4UAB
num_of_fireplaces__c, 1
num_of_rooms__c, 13
of_units__c, 0
address2__c, 737 Huron Avenue, San Francisco, CA, 94112
pba__address_pb__c, 737 Huron Avenue, San Francisco, CA, 94112
agent_only_remarks__c, We received multiple preemptive offers after the first weekend of open houses and just before we were going to set an offer date. Apologies to those who didn't get a chance to submit. Text/email Rob Mitchell (415)902-4060 or [email protected] for showings. Not using 'Showing Time.' Property website: www.737huron.com. Contact agent for Disclosures. Must be on 7pg SFAR purchase agreement only. (one can be provided if needed) Please include with offer: language on Tesla solar, Proof of Funds, Pre-Approval Letter, Disclosures Cover Sheet,condition that all disclosures will be fully signed and delivered within 24 hours of acceptance. Please do NOT provide buyer's letter or picture with the offer. Seller reserves the right to accept or reject any and all offers. Buyer's should verify square footage, room count, and if garage and driveway will accommodate their car(s).
appliances__c, Dishwasher;Disposal;Hood Over Range;ENERGY STAR Qualified Appliances
architectural_style__c, Marina
bath_features__c, Dual Flush Toilet
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 6
year_build_text__c, 1928
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-03-08T19:51:18.000+0000
days_on_market__c, 438
dom__c, 6
ffd_description_pb, Stunning Marina Style home in desirable Outer Mission neighborhood. Extensively renovated and updated with great attention to detail throughout. This bright and airy 6 bed 4 bath home offers generous living space on two floors, and is situated on a tranquil oversized lot on a quiet street. 737 Huron Avenue is a commuter's dream with easy access to freeways, BART and Muni. The Outer Mission neighborhood has a distinct charm all its own. Largely residential, it is removed from the more heavily-trafficked areas of city life but close to everything. This property is a five-minute walk to Cayuga Park and Playground where you'll find basketball and tennis courts. Chef's dream kitchen with quartz counters, new appliances, luxury bathrooms, hardwood floors, built-in sound system and more. Tesla solar system to reduce your electricity bills and sell power back to the grid. Room for 3 cars.
district__c, SF District 10
electric__c, 220 Volts,Photovoltaics Seller Owned
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Fenced
fireplace_features__c, Electric
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2023-05-15T22:48:58.000+0000
pba__latitude_pb__c, 37.711512
pba__latitude_property__c, 37.711512
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2022-03-04
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Robert
pba__listing_agent_lastname__c, Mitchell
listing_agent_mls_id__c, 814030
ffd_listingagentname, Rob Mitchell
listing_agent_number__c, 1064061
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CGL01
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28273
pba__listingprice_pb__c, 1583000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.449864
lower_level__c, Bedroom(s),Full Bath(s),Garage,Primary Bedroom
mls_id__c, 422635401
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Low-Flow Toilet(s);Tile;Dual Flush Toilet
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2022-03-04
original_price__c, 1583000
overall_days_on_market__c, -81146
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-03-10
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 813.01
pba__propertytype__c, Single Family Residence
id, a0E8W00000Vtla4UAB
road_surface_type__c, Asphalt
roof__c, Bitumen
room_type__c, Kitchen;Great Room;Wine Storage Area;Home Theater;Primary Bedroom 2+
sale_date__c, 2022-04-01
sale_price__c, 2000000
security_features__c, Smoke Detector;Security Fence;Secured Access;Carbon Mon Detector;Video System;Double Strapped Water Heater
selling_agent_mls_id__c, 800917
selling_agent_number__c, 800917
selling_co_agent_mls_id__c, 815826
selling_co_agent_number__c, 1074832
selling_co_office_mls_id__c, VANG03
selling_co_office_name__c, Vanguard Properties
selling_co_office_number__c, 1228
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 2460
size__c, 2460
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Huron
subdist__c, Outer Mission
ffd_name, 737 Huron Avenue, San Francisco, CA, 94112
view__c, Hills
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Window Coverings;Bay Window(s);Window Screens
pba__yearbuilt_pb__c, 1928
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530412843-1.jpg
ListingId, a0E8W00000Vtla4UAB
_wp_old_slug, 737-huron-avenue-san-francisco-ca-94112-3