meta_query='key:subdist__c;value:Outer Richmond|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210106' 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, 650 38th Avenue, San Francisco, CA, 94121
ffd_mls_id, 494979
ffd_salesforce_id, a0E1I00000QrdFtUAJ
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
address2__c, 650 38th Avenue, San Francisco, CA, 94121
pba__address_pb__c, 650 38th Avenue, San Francisco, CA, 94121
agent_only_remarks__c, ***OFFER DATE: Wednesday, 2/26 at Noon*** Pre-Escrow opened with Kelley Kish, [email protected] Please submit offer with fully signed disclosure and proof of funds. And for non-contingent offers please include selling agent AVID. Property Website with floor plans and virtual walk-through https://www.650-38thave.com/
appliances__c, Dishwasher;Gas Range;Disposal;Hood Over Range;Tankless Water Heater
bath_features__c, Remodeled;Bidet
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 1931
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-02-14T11:46:19.000+0000
days_on_market__c, 1252
dom__c, 13
ffd_description_pb, Completely renovated in 2017, this stunning 4 BD, 4 BA home boasts updated HVAC and electrical systems, beautiful hickory floors, and recessed lighting throughout. Vaulted ceilings rise over a bright, spacious living room anchored by a gorgeous fireplace. Off the formal dining room lies a sun-drenched patio and open kitchen with Thermador appliances, quartz counters, custom cabinetry, and a large island. 2 sunny bedrooms, including a master suite, overlook the backyard. Downstairs, there is a family room with a wet bar and two bedrooms - one leads to the expansive, manicured backyard. Located in the heart of the Richmond, your new home is steps from Golden Gate Park, shopping, dining, and public transit along the vibrant Balboa corridor.
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
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
ffd_lastmodifieddate, 2022-01-12T15:27:54.000+0000
pba__latitude_pb__c, 37.776599
pba__latitude_property__c, 37.776599
laundry_features__c, Washer/Dryer Included;In Basement
listed_date__c, 2020-02-13
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Robert
pba__listing_agent_lastname__c, Moffatt
listing_agent_mls_id__c, 806265
ffd_listingagentname, Robert N Moffatt
listing_agent_number__c, 166016636
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, MCGU05
listing_office_name__c, McGuire Real Estate
listing_office_number__c, 166014082
pba__listingprice_pb__c, 1695000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=B2xkk5qG9g8
pba__longitude_pb__c, -122.498131
pba__lotsize_pb__c, 0.07
lower_level__c, Bedroom(s),Family Room,Master Bedroom
mls_id__c, 494979
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-02-13
original_price__c, 1695000
overall_days_on_market__c, 90
parking__c, Carport,Garage
parking_features__c, Carport,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-02-26
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 890.56
pba__propertytype__c, Single Family Residence
id, a0E1I00000QrdFtUAJ
sale_date__c, 2020-03-27
sale_price__c, 2075000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 809119
selling_agent_name__c, Judson B. Gregory
selling_agent_number__c, 1040495
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2330
size__c, 2330
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 38th
subdist__c, Outer Richmond
ffd_name, 650 38th Avenue, San Francisco, CA, 94121
transportation__c, 1 Block
website_property_type__c, Single Family Home
window_features__c, Dual Pane
pba__yearbuilt_pb__c, 1931
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/360331-1.jpg
ListingId, a0E1I00000QrdFtUAJ