meta_query='key:subdist__c;value:Central Richmond|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210146' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70208
[post_author] => 4
[post_date] => 2018-11-30 20:29:21
[post_date_gmt] => 2018-11-30 20:29:21
[post_content] => What used to be rolling sand dunes as far as the eye can see is now an orderly neighborhood of tidy homes. Views of the Golden Gate Bridge are a welcome surprise from the lucky parts. Proximity to the park appeals to those with canines and kids.
[post_title] => Central Richmond
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => central-richmond
[to_ping] =>
[pinged] =>
[post_modified] => 2018-11-30 20:29:21
[post_modified_gmt] => 2018-11-30 20:29:21
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70208
[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 638 29th Avenue, San Francisco, CA, 94121
ffd_mls_id 495087
ffd_salesforce_id a0E1I00000RN5bBUAT
num_of_fireplaces__c 1
num_of_rooms__c 6
of_units__c 0
address2__c 638 29th Avenue, San Francisco, CA, 94121
pba__address_pb__c 638 29th Avenue, San Francisco, CA, 94121
agent_only_remarks__c Trust Sale. No court confirmation. Death on property, 1/1/19, of natural causes. The attic (previously used as storage space), 1-2pm Attic showing cancelled. Hinge broke. Open to view from 2nd floor. Zoned RH-2. Check with planning dept for expansion possibilities. Offer due Tuesday, March 10th by 12 noon. No pre-emptive offer. .Disclosures: https://app.disclosures.io/link/638-29th-Avenue-kbitkprl
bath_features__c Shower Stall(s);Tub;Tile;Sauna
pba__fullbathrooms_pb__c 1
pba__bedrooms_pb__c 2
year_build_text__c 1914
pba__city_pb__c San Francisco
listing_co_agent_name__c Norm Fung
pba__contingentdate__c 1800-01-01
ffd_createddate 2020-02-27T11:45:53.000+0000
days_on_market__c 966
dom__c 13
ffd_description_pb Charming 1914-built home features a formal living room, open-concept kitchen/dining room, large private backyard, and an undeveloped attic space for tons of storage. The lower level includes a 1-car garage, additional storage, and undeveloped space for potential expansion. Great location for schools: Katherine Delmar Burke, Presidio Middle, Washington High. Recreation opportunities abound: Fulton Playground, Golden Gate Park, Legion of Honor, Lincoln Park, Lands End, and The Presidio. Proximity to commercial corridors: Geary, Clement, and Balboa Village. Don't miss this rare opportunity to put your own stamp on this charming single family home in the coveted Central Richmond District. Diamond in the rough! Bring your imagination & designers to this Fixer Upper!
district__c SF District 1
driveway_sidewalks__c Paved Driveway
electric__c 220 Volts in Laundry
entry_level__c 0
external_listing__c 1
fencing__c Fenced Yard
fireplace_features__c Wood Burning
pba__floortype_pb__c Wood
hoa_dues__c 0
pba__hoafees__c 0
pba__halfbathrooms_pb__c 0
pba__heatingtype_pb__c Central
ffd_lastmodifieddate 2022-01-12T15:28:03.000+0000
pba__latitude_pb__c 37.777222
pba__latitude_property__c 37.777222
listed_date__c 2020-02-17
pba__listing_agent_email__c pat@mosaikrealestate.com
pba__listing_agent_firstname__c Patricia
pba__listing_agent_lastname__c Lee
listing_agent_mls_id__c 806248
ffd_listingagentname Pat Lee
listing_agent_number__c 166016601
listing_co_agent_mls_id__c 807901
listing_co_agent_number__c 1028392
listing_co_office_mls_id__c ZEPH06
listing_co_office_name__c Zephyr Real Estate
listing_co_office_number__c 166014343
listing_office_mls_id__c ZEPH
listing_office_name__c Zephyr Real Estate
listing_office_number__c 2263
pba__listingprice_pb__c 998000
pba__listingtype__c Sale
pba__longitude_pb__c -122.488492
pba__lotsize_pb__c 0.07
mls_id__c 495087
main_level__c Kitchen;Living Room;Dining Room
monthly_parking_fees__c 0
monthlyrent__c 0
parkingspaces__c 1
on_market_date__c 2020-02-27
original_price__c 998000
overall_days_on_market__c 308
parking__c Attached,Garage
parking_access__c Independent
parking_features__c Attached,Garage
parking_type__c On Site (Single Family Only)
pba__pendingdate__c 2020-03-11
possible_bedrooms__c 0
pba__pricechangedat__c 1800-01-01T00:00:00.000+0000
price_per_square_foot__c 663.41
pba__propertytype__c Single Family Residence
id a0E1I00000RN5bBUAT
room_type__c Sun Room;Laundry
sale_date__c 2020-03-23
sale_price__c 1360000
selling_agent_mls_id__c 401740
selling_agent_name__c Karen Mendelsohn Gould
selling_agent_number__c 401740
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 2050
size__c 2050
pba__state_pb__c CA
stories__c 0
pba__street_pb__c 29th
subdist__c Central Richmond
ffd_name 638 29th Avenue, San Francisco, CA, 94121
transportation__c 1 Block
website_property_type__c Single Family Home
pba__yearbuilt_pb__c 1914
pba__postalcode_pb__c 94121
ffd_media Array
ffd_media_tags Array
ffd_featured_image https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/360430-1.jpg
ListingId a0E1I00000RN5bBUAT