meta_query='key:subdist__c;value:Outer Richmond|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='221644' 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, 659 48th Avenue, San Francisco, CA, 94121
ffd_mls_id, 421604175
ffd_salesforce_id, a0E8W00000V0rzhUAB
num_of_fireplaces__c, 0
num_of_rooms__c, 7
of_units__c, 0
address2__c, 659 48th Avenue, San Francisco, CA, 94121
pba__address_pb__c, 659 48th Avenue, San Francisco, CA, 94121
agent_only_remarks__c, Per request of Seller, showings by appointment only - but easy to show otherwise. Sale includes two lots APN 1591-004 and APN 1591-005A. Disclosures available. Pre-sale escrow opened with Fidelity/Lynn Chan. Buyer to verify all square footage to their own satisfaction. Seller reserves right to accept, reject or counter any offers received.
appliances__c, Dishwasher;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Mid-Century
bath_features__c, Shower Stall(s);Tub;Tile;Window;Jack & Jill
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1951
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Peggy M Wallace
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2021-10-18T18:50:21.000+0000
days_on_market__c, 639
dom__c, 18
ffd_description_pb, Spectacular views await w/ a sweeping panorama from The Pacific Ocean, Ocean Beach, Seal Rocks, Kelly's Cove, Golden Gate Park, Sutro Tower to San Bruno State Mountain Park. Be filled with serenity in the massive Living Room w/ nearly 360 degree views of Ocean Beach & the Pacific Ocean. Constantly varying light spectrum from the Pacific Ocean & Skies will mesmerize you. Main Level also provides an Updated Kitchen, 2 Bedrooms & a Vintage Full Bath w/ striking views of the coastline & ocean while the Lower Lower Level has a grand Primary en Suite Bedroom w/unbelievable views as well as a Laundry Room & space for a personal Gym. Ground Level to the Backyard features bonus potential w/grand ceiling height & enough area for endless opportunities! Easy access to Ocean Beach is surfer heaven. Awake daily to frolic in waves or take in the view w/ a cup of coffee or glass of champagne. Corner home w/ unparalleled views & double-lot is special -- a legacy home for its next fortunate caretakers.
district__c, SF District 1
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Floor Furnace
interior_features__c, Skylight(s);Open Beam Ceiling
ffd_lastmodifieddate, 2022-01-25T16:04:46.000+0000
pba__latitude_pb__c, 37.7759476
pba__latitude_property__c, 37.7759476
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2021-10-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Carol
pba__listing_agent_lastname__c, Reen
listing_agent_mls_id__c, 808330
ffd_listingagentname, Carol Reen
listing_agent_number__c, 1033515
listing_co_agent_mls_id__c, 810811
listing_co_agent_number__c, 1048238
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 3995000
pba__listingtype__c, Sale
pba__listing_website__c, https://youtu.be/nwV-BvNoIF8
pba__longitude_pb__c, -122.5094049
lower_level__c, Master Bedroom
mls_id__c, 421604175
main_level__c, Bedroom(s);Kitchen;Garage;Living Room;Street Entrance
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 4
on_market_date__c, 2021-10-18
original_price__c, 3995000
overall_days_on_market__c, 286
parking_access__c, Tandem
parking_features__c, Attached,Garage Door Opener,Garage Facing Front,Uncovered Parking Space,Uncovered Parking Spaces 2+
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2021-11-05
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 2049.18
pba__propertytype__c, Single Family Residence
id, a0E8W00000V0rzhUAB
room_type__c, Bonus Room;Laundry;Kitchen;Living Room;Master Bathroom;Family Room;Great Room
sale_date__c, 2021-11-30
sale_price__c, 5000000
security_features__c, Window Security Bars;Security System Leased
selling_agent_mls_id__c, 810107
selling_agent_number__c, 1044745
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Global Living
pba__status__c, Closed
pba__totalarea_pb__c, 2440
size__c, 2440
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 48th
subdist__c, Outer Richmond
ffd_name, 659 48th Avenue, San Francisco, CA, 94121
view__c, Ocean;Park;City Lights;Garden/Greenbelt;Water;Mountains;Sutro Tower
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1951
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530343439-1.jpg
ListingId, a0E8W00000V0rzhUAB