meta_query='key:subdist__c;value:Outer Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='219420' 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] => 2024-04-12 12:18:59
[post_modified_gmt] => 2024-04-12 19:18:59
[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, 657 Huron Avenue, San Francisco, CA, 94112
ffd_mls_id, 421561999
ffd_salesforce_id, a0E1I00000UU8y0UAD
num_of_fireplaces__c, 1
num_of_rooms__c, 9
of_units__c, 0
address2__c, 657 Huron Avenue, San Francisco, CA, 94112
pba__address_pb__c, 657 Huron Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Supra is on, Please go directly, no CBS code needed. Ellis act restrictions apply to the entire property, owner of this property needs to file annual reports through December 2023, buyers should consult with their attorney if needed. You can review the seller package through this link: https://app.disclosures.io/link/657-Huron-Avenue-cmw2xk0v. Due to high demand, please text or email the agent 650-642-5548 if any question. No preemptive offer allowed, sellers reserve right to reject, counter or accept any offers. Offer due at 2:00 PM on 06/22/21. Please email offer to: [email protected].
appliances__c, Dishwasher;Gas Water Heater;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator;Gas Cook Top
architectural_style__c, Traditional
bath_features__c, Tub w/Shower Over;Tub;Tile
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1928
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2021-06-11T20:48:29.000+0000
days_on_market__c, 768
dom__c, 11
ffd_description_pb, Location! Location! Location! Rare find beautifully remodeled fully detached home with extra large lot size 3,510 SF located on the quiet block in the convenient Outer Mission neighborhood. It is at great move-in condition! Upper level features spacious formal living room, stunning large kitchen with modern design and high end materials, comfortable dinning room with lots of natural lights, 2 bedrooms, 1 den, 1 bath, nice deck is off the kitchen and den, hardwood floors throughout, double pane windows. Lower level feature 2 small master suites, bonus room, with separate entrance. Extra large back yard, with great potential! Walking distance to schools, Chinese super market, and the stores, bank, restaurants, bus stations on mission street, it is near BART station, easy access to freeway 101 and 280. Such a dream home, you can enjoy here for years to come......
district__c, SF District 10
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Tile;Vinyl;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas;Fireplace(s)
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-01-25T15:54:53.000+0000
pba__latitude_pb__c, 37.712449
pba__latitude_property__c, 37.712449
laundry_features__c, In Garage;Hookups Only
listed_date__c, 2021-06-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ken
pba__listing_agent_lastname__c, Kwok
listing_agent_mls_id__c, 981462
ffd_listingagentname, Ken K Kwok
listing_agent_number__c, 981462
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, MXRE1
listing_office_name__c, MaxReal
listing_office_number__c, 25562
pba__listingprice_pb__c, 999000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.448643
lower_level__c, Bedroom(s),Full Bath(s),Garage,Master Bedroom,Street Entrance
mls_id__c, 421561999
master_bathroom_features__c, Shower Stall(s);Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-06-11
original_price__c, 999000
overall_days_on_market__c, 111
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Garage Facing Front
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-06-22
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 746.67
pba__propertytype__c, Single Family Residence
id, a0E1I00000UU8y0UAD
roof__c, Tar/Gravel;Composition;Shingle;Other
room_type__c, Storage;Bonus Room;Kitchen;In Law Apartment;Living Room;Dining Room;Master Bedroom
sale_date__c, 2021-08-04
sale_price__c, 1400000
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector
selling_agent_mls_id__c, 812162
selling_agent_number__c, 1055242
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, eXp Realty of California, Inc
pba__status__c, Closed
pba__totalarea_pb__c, 1875
size__c, 1875
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Huron
subdist__c, Outer Mission
ffd_name, 657 Huron Avenue, San Francisco, CA, 94112
view__c, City Lights
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
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/530260901-1.jpg
ListingId, a0E1I00000UU8y0UAD