meta_query='key:subdist__c;value:Outer Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='320344' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12157
[post_author] => 4
[post_date] => 2018-10-29 01:19:09
[post_date_gmt] => 2018-10-29 01:19:09
[post_content] => Let’s play a San Francisco word association game. I say, “Outer Sunset.” You say, “Fog.” Right? Yes, it’s foggy -- sometimes -- but it’s also developed a reputation as a beach community with surfers, some excellent local restaurants, and quirky shops.
[post_title] => Outer Sunset
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => outer-sunset
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-11 08:40:45
[post_modified_gmt] => 2024-04-11 15:40:45
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12157
[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, 1254 38th Avenue, San Francisco, CA, 94122
ffd_mls_id, 422689054
ffd_salesforce_id, a0E8W00000ZKmV9UAL
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 1254 38th Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1254 38th Avenue, San Francisco, CA, 94122
agent_only_remarks__c, Price Reduced 10/19!! Open houses this weekend. Lower level legality is unknown, buyer to investigate. Very easy to show. Code available upon request. Please email [email protected] for access information. Please use SFAR Purchase Agreement for offers.
appliances__c, Microwave;Hood Over Range;Free Standing Refrigerator;Free Standing Freezer
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1940
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Derek B Schreiber
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-10-07T18:47:23.000+0000
days_on_market__c, 285
dom__c, 18
ffd_description_pb, Semi-detached home in prime Outer Sunset location, steps from the entrance to Golden Gate Park and a short stroll to Ocean Beach. Elegant original molding including beautiful parquet wood floors. Upon entering the foyer, find a bright living room with fireplace and oversized windows that flood the room with Westerly light. Down the atrium lit hall, a large eat-in kitchen with stainless steel appliances. 3 bedrooms and 2 bathrooms complete the main level, including the primary suite with en suite bath and walk-in closet with original built-in vanity. An additional bedroom, full bath with jacuzzi tub bath and family room are located downstairs, providing a perfect visitors suite, home office, or both! Flat yard with luscious lawn and attached deck. Spring will be abundant with mature fig, lemon, cherry, apricot, plum, and lime trees. Spacious garage with interior access, storage, work bench, and EV-charging station. Driveway w/ add'l 1-car pkg. Convenient to all of your favorite spots like Trouble Coffee, Hook Fish, Other Avenues Co-op Grocery, Outerlands and more!
district__c, SF District 2
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room
pba__floortype_pb__c, Wood;Parquet
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry;Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2023-07-13T17:33:37.000+0000
pba__latitude_pb__c, 37.7634783
pba__latitude_property__c, 37.7634783
laundry_features__c, Washer/Dryer Stacked Included;Ground Floor
listed_date__c, 2022-08-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Gillian
pba__listing_agent_lastname__c, Pontes
listing_agent_mls_id__c, 803853
ffd_listingagentname, Gillian S Pontes
listing_agent_number__c, 166013117
listing_co_agent_mls_id__c, 806014
listing_co_agent_number__c, 166016147
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, 1395000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.49735
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage,Street Entrance
mls_id__c, 422689054
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Street Entrance;Primary Bedroom
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-10-07
original_price__c, 1695000
overall_days_on_market__c, -81363
parking_access__c, Tandem
parking_features__c, Attached,Enclosed,EV Charging,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-10-25
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 794.04
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000ZKmV9UAL
sale_date__c, 2022-12-08
sale_price__c, 1600000
selling_agent_mls_id__c, 816319
selling_agent_number__c, 1075280
selling_co_agent_mls_id__c, 813428
selling_co_agent_number__c, 1061215
selling_co_office_mls_id__c, VANG02
selling_co_office_name__c, Vanguard Properties
selling_co_office_number__c, 166013449
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 2015
size__c, 2015
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 38th
subdist__c, Outer Sunset
ffd_name, 1254 38th Avenue, San Francisco, CA, 94122
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1940
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530517241_ae703efb-2ebb-49a5-9701-b3d7cec5fa24.jpg