meta_query='key:subdist__c;value:Outer Richmond|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='329986' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12161
[post_author] => 4
[post_date] => 2018-10-29 17:16:40
[post_date_gmt] => 2018-10-29 17:16:40
[post_content] => Fog-cooled Outer Richmond beckons those who want to make a sleepier corner of the City home. The Cliff House, Sutro Baths, and Lands End are nearby iconic San Francisco landmarks. Welcome home, surfers, dog walkers, beachcombers, and lovers of Golden Gate Park.
[post_title] => Outer Richmond
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => outer-richmond
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 12:20:40
[post_modified_gmt] => 2024-03-19 19:20:40
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12161
[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, 747 38th Avenue, San Francisco, CA, 94121
ffd_mls_id, 423723239
ffd_salesforce_id, a0E8W00000bErwuUAC
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 747 38th Avenue, San Francisco, CA, 94121
pba__address_pb__c, 747 38th Avenue, San Francisco, CA, 94121
agent_only_remarks__c, UP Date 3/6/23: Offers Due by 3/13 12:00 p.m. Contact Grace Louie (text) after 3/13 for appointments 415-420-8983. Up Date: Open houses and tour is scheduled. Please use CAR-RPA and email all offers to: [email protected]. Trust Sale, Ting Kai Louie and Yuet Shim Chan, Trustees of the Ting Kai Louie and Yuet Shim Chan Revocable Living trust dated 2/05/2010, no pending issues Pre Escrow with DOMA #56604220224. Disclosures will be available after 3/7.
appliances__c, Dishwasher;Gas Water Heater;Disposal;Gas Plumbed
architectural_style__c, Bungalow
bath_features__c, Tub w/Shower Over;Tile;Low-Flow Toilet(s);Window
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1924
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Grace M. Louie
pba__contingentdate__c, 2023-03-13
ffd_createddate, 2023-03-01T20:47:50.000+0000
days_on_market__c, 140
dom__c, 13
ffd_description_pb, It's back. A perfect opportunity to create your home. Just to give you a few ideas we've created a Virtual Restoration / staging snap shots. Visualizing the possibilities are endless and for only you to create. Great location, Front of the house faces East to capture the morning sun. Wide street, walking distance to Golden Gate Park and Ocean Beach, not to mention the ample amount of restaurants to choose from for any given day. Neighborhood stores just around the corner. Location!
district__c, SF District 1
driveway_sidewalks__c, Sidewalk/Curb/Gutter
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Wood Burning;Brick;Stone
pba__floortype_pb__c, Carpet;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2023-07-13T18:28:55.000+0000
pba__latitude_pb__c, 37.774774
pba__latitude_property__c, 37.774774
laundry_features__c, In Garage;Hookups Only;In Basement;Sink
listed_date__c, 2023-02-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, Oei
listing_agent_mls_id__c, 803032
ffd_listingagentname, John I Oei
listing_agent_number__c, 803032
listing_co_agent_mls_id__c, MLSL5088896
listing_co_agent_number__c, 981372288
listing_co_office_mls_id__c, APFS-1
listing_co_office_name__c, April Financial Services
listing_co_office_number__c, 981050909
listing_office_mls_id__c, APRIL
listing_office_name__c, April Realty
listing_office_number__c, 26456
pba__listingprice_pb__c, 1088000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4985827
lower_level__c, Garage
mls_id__c, 423723239
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2023-03-01
original_price__c, 1088000
overall_days_on_market__c, -81508
pba__pendingdate__c, 2023-03-14
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1092.44
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bErwuUAC
roof__c, Tar/Gravel;Other
room_type__c, Kitchen;Living Room;Dining Room;Other;Primary Bedroom 2+
sale_date__c, 2023-04-17
sale_price__c, 1300000
security_features__c, Window Security Bars;Other
selling_agent_mls_id__c, 666666
selling_agent_number__c, 666666
selling_co_agent_mls_id__c, 666666
selling_co_agent_number__c, 666666
selling_co_office_mls_id__c, NMSS
selling_co_office_name__c, April Realty
selling_co_office_number__c, 2691
selling_office_name__c, April Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1190
size__c, 1190
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 38th
subdist__c, Outer Richmond
ffd_name, 747 38th Avenue, San Francisco, CA, 94121
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1924
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530585482-1.jpg