meta_query='key:subdist__c;value:Outer Richmond|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215993' 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, 643 40th Avenue, San Francisco, CA, 94121
ffd_mls_id, 509854
ffd_salesforce_id, a0E1I00000Tl8SWUAZ
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 643 40th Avenue, San Francisco, CA, 94121
pba__address_pb__c, 643 40th Avenue, San Francisco, CA, 94121
agent_only_remarks__c, Easy to show by appointment. Please follow CA-OSHA showing guideline and send PEAD-V & Pre-Approval letter before showing. For more information, please contact Rachel at 415-867-8815 or [email protected] Seller reserves the right to counter/reject any offers.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Freestanding Range;Hood Over Range
architectural_style__c, Marina
bath_features__c, Tub w/Shower Over;Remodeled;Marble
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1924
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-12-04T22:46:14.000+0000
days_on_market__c, 978
dom__c, 71
ffd_description_pb, Beautiful Move-In Ready Richmond District Home! Welcome to this tastefully renovated light-filled residence with classic period details, hardwood floors and a deluxe chef's kitchen featuring top of the line Wolf, Sub Zero, Bosch and Fisher Paykel appliances. On the main level enjoy the expansive formal living room with picture windows and gas burning fireplace, large formal dining room and stunning bathroom with floor to ceiling marble tile and soaking tub. The main level also offers 2 bedrooms including a master suite with walk-in closet and partial ocean views, and an additional large bedroom. Enjoy the skylit patio off the dining room wonderfully reimagined into a Parisian bistro perfect for your morning cappuccino made by your built-in Bosch coffee machine. The downstairs bedroom is also ideal as a family room or office perfect for working from home! The sunny backyard is an oasis for relaxation and has been meticulously landscaped into an enchanting English garden.3 car parking
district__c, SF District 1
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room;Gas Starter
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-01-25T15:39:57.000+0000
pba__latitude_pb__c, 37.776589
pba__latitude_property__c, 37.776589
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-11-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Rachel
pba__listing_agent_lastname__c, Kwok
listing_agent_mls_id__c, 804783
ffd_listingagentname, Rachel L Kwok
listing_agent_number__c, 166014461
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1995000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.643-40thave.com/
pba__longitude_pb__c, -122.5008641
pba__lotsize_pb__c, 0.07
lower_level__c, Bedroom(s),Partial Bath(s)
mls_id__c, 509854
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2020-11-13
original_price__c, 1995000
overall_days_on_market__c, 107
parking__c, Attached,Garage,Auto Door
parking_features__c, Attached,Garage Door Opener,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-01-27
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
id, a0E1I00000Tl8SWUAZ
sale_date__c, 2021-02-08
sale_price__c, 2050000
selling_agent_mls_id__c, 808937
selling_agent_number__c, 1038623
selling_co_agent_mls_id__c, 808971
selling_co_agent_number__c, 1038794
selling_co_office_mls_id__c, COMP
selling_co_office_name__c, Compass
selling_co_office_number__c, 26293
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 40th
subdist__c, Outer Richmond
ffd_name, 643 40th Avenue, San Francisco, CA, 94121
transportation__c, 1 Block
view__c, Ocean;Partial
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/373717-1.jpg
ListingId, a0E1I00000Tl8SWUAZ