meta_query='key:subdist__c;value:Central Richmond|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='345725' 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] => 2023-10-31 10:57:39
[post_modified_gmt] => 2023-10-31 17:57:39
[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
(
)
)
_yoast_indexnow_last_ping, 1700223216
ffd_listing_title, 719 29th Avenue, San Francisco, CA, 94121
ffd_mls_id, 423912724
ffd_salesforce_id, a0E8W00000dUHDrUAO
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 719 29th Avenue, San Francisco, CA, 94121
pba__address_pb__c, 719 29th Avenue, San Francisco, CA, 94121
agent_only_remarks__c, First open house Saturday, October 7th and Sunday, October 8th 2-4pm. Lockbox will be installed after first open house. Offer date set for October 16th by 11am. Please call listing agents with any questions. Tanya Dzhibrailova 415-531-6779 or Neil H. Bui 510-388-2956. Disclosure Disclosure package link: https://app.disclosures.io/link/719-29th-Avenue-aim4fora
appliances__c, Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Traditional
bath_features__c, Tile
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, Jannie Chen
pba__contingentdate__c, 2023-10-17
cooling__c, None
ffd_createddate, 2023-10-06T22:47:41.000+0000
days_on_market__c, 42
dom__c, 17
ffd_description_pb, Wonderful Single Family Richmond District Home with Hillside Views. Don't miss the opportunity to own this Single Family Home with 3 Bedrooms / 1 Bathroom in the heart of the Richmond District. With recently refinished hardwood floors, new stainless steel appliances, living room with wood burning fireplace, formal dining room, and spacious landscaped backyard, this home checks all the boxes. The home includes two car garage parking, washer, dryer, updated light fixtures, and much more. Just a block from Golden Gate Park, and minutes to Sea Cliff or Ocean Beach, it's the perfect location to enjoy all that San Francisco has to offer. Enjoy your walk to the restaurants and shops on Balboa Street, or venture North to the vibrant Geary Street area. Whatever your interests, 29th Avenue is the perfect home for any buyer.
district__c, SF District 1
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Laminate;Linoleum;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2023-11-17T11:47:17.000+0000
pba__latitude_pb__c, 37.775677
pba__latitude_property__c, 37.775677
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2023-10-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Neil Huy
pba__listing_agent_lastname__c, Bui
listing_agent_mls_id__c, 817040
ffd_listingagentname, Neil H Bui
listing_agent_number__c, 1075948
listing_co_agent_mls_id__c, 816217
listing_co_agent_number__c, 1075190
listing_co_office_mls_id__c, NHBR
listing_co_office_name__c, NHB Real Estate, Inc.
listing_co_office_number__c, 28887
listing_office_mls_id__c, NHBR
listing_office_name__c, NHB Real Estate, Inc.
listing_office_number__c, 28887
pba__listingprice_pb__c, 1095000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.719-29thave.com/mls/115633531
pba__longitude_pb__c, -122.4889453
lower_level__c, Street Entrance
mls_id__c, 423912724
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Tub w/Shower Over;Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-10-06
original_price__c, 1095000
overall_days_on_market__c, -81727
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-10-23
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-11-16T17:29:50.000+0000
price_per_square_foot__c, 1038.21
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000dUHDrUAO
room_type__c, Kitchen;Living Room;Baths Other;Dining Room;Primary Bedroom 2+
sale_date__c, 2023-11-15
sale_price__c, 1250000
security_features__c, Security Gate
selling_agent_mls_id__c, MLSL5072595
selling_agent_number__c, 981224315
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Signature Properties
pba__status__c, Closed
pba__totalarea_pb__c, 1204
size__c, 1204
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 29th
subdist__c, Central Richmond
ffd_name, 719 29th Avenue, San Francisco, CA, 94121
view__c, Garden/Greenbelt
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/530689033-1.jpg