meta_query='key:subdist__c;value:Central Richmond|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218575' 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] => 2024-04-09 10:27:28
[post_modified_gmt] => 2024-04-09 17:27:28
[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, 254 20th Avenue, San Francisco, CA, 94121
ffd_mls_id, 421543498
ffd_salesforce_id, a0E1I00000USMCVUA5
num_of_fireplaces__c, 1
num_of_rooms__c, 11
of_units__c, 0
address2__c, 254 20th Avenue, San Francisco, CA, 94121
pba__address_pb__c, 254 20th Avenue, San Francisco, CA, 94121
agent_only_remarks__c, Please see www.254-20thAve.com for Floor Plans w/ square footage breakouts, and 3D Matterport Virtual Tour. To schedule showing: https://calendly.com/wgre/254-20th-avenue or contact John Montgomery via email at [email protected] or via text/call to 415.609.4595 (cell) to arrange a private showing (hosted by listing agent). Home is currently owner-occupied. Please submit all offers using SFAR Purchase Agreement and include a signed disclosure package cover sheet. Disclosures include a detailed home inspection report and pest report. Disclosures are ready and available. Please email John Montgomery to obtain disclosures. Two (2) small-to-medium cars fit tandem inside garage given 30'-6" inside garage depth from garage door inside face to front wall but (1) car independent allows for more extra storage space and elbow room. Seller parks one car in garage and 'guerilla' parks across the curb cut for their second car to maximize the storage space in garage for kids stuff, surfboards and other gear.
architectural_style__c, Traditional
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1912
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-04-30T00:47:36.000+0000
days_on_market__c, 811
dom__c, 11
ffd_description_pb, With all bedrooms located on the Top Level, this remodeled turn-key home w/ great flow has it all. A large 2016 remodel expansion + updated 2021 finishes create welcome living spaces that seamlessly embrace the outdoors creating fantastic indoor-outdoor connections. Playful elements enhance the experience such as a secret room behind a bookcase, outdoor shower and a strategically placed chalk board. Main Level: chef's kitchen w/ kitchen island and waterfall edge, breakfast area, formal din room, full lot width 25' wide deck that is also a generous 10' deep w/ built-in heat provides and direct access to yard provides a year-round entertaining. Lower Level: boasts a large media room, office and bathroom w/ plenty of storage and direct access to yard. Master suite bath has under-tile radiant floor heating. Close to Baker Beach, Mountain Lake Park, The Presidio, GG Park, Land's End, playgrounds, local dining and a lively Sunday farmer's market makes living here a rewarding experience.
district__c, SF District 1
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Gas Starter
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2022-01-25T15:51:05.000+0000
pba__latitude_pb__c, 37.7830931
pba__latitude_property__c, 37.7830931
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2021-04-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, Montgomery
listing_agent_mls_id__c, 802689
ffd_listingagentname, John R Montgomery
listing_agent_number__c, 802689
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, WGRE
listing_office_name__c, West Group Real Estate
listing_office_number__c, 2843
pba__listingprice_pb__c, 3495000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=o7B4XyvvcdH&mls=1
pba__longitude_pb__c, -122.4794121
mls_id__c, 421543498
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tile;Marble;Window
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-04-29
original_price__c, 3495000
overall_days_on_market__c, 365
parking_access__c, Independent
parking_features__c, 24'+ Deep Garage,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-05-10
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1189.75
pba__propertytype__c, Single Family Residence
id, a0E1I00000USMCVUA5
room_type__c, Office;Kitchen;Living Room;Master Bathroom;Dining Room;Master Bedroom;Media Room;Home Theater
sale_date__c, 2021-06-04
sale_price__c, 3875000
selling_agent_mls_id__c, 807674
selling_agent_number__c, 1023667
selling_co_agent_mls_id__c, 803159
selling_co_agent_number__c, 803159
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, 3257
size__c, 3257
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 20th
subdist__c, Central Richmond
ffd_name, 254 20th Avenue, San Francisco, CA, 94121
view__c, Golden Gate Bridge
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1912
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530228795-1.jpg
ListingId, a0E1I00000USMCVUA5