meta_query='key:subdist__c;value:Outer Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='326264' 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] => 2018-10-29 01:19:09
[post_modified_gmt] => 2018-10-29 01:19:09
[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, 1706 42nd Avenue, San Francisco, CA, 94122
ffd_mls_id, 423713982
ffd_salesforce_id, a0E8W00000a6ytJUAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 1706 42nd Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1706 42nd Avenue, San Francisco, CA, 94122
agent_only_remarks__c, Offers, if any, to be presented to listing agents by noon this Thursday 1/19. Great newly remodeled single family home. Newly remodeled kitchen, bathroom, new flooring, lighting, interior and exterior paint and landscaping in front and backyard. Lower level includes spacious garage with storage/bonus room area. Deep garage could potentially accommodate 2 car tandem parking. Possible expansion potential. Landscaped level and fully fenced rear garden. Do NOT use Showing Time. Email listors for disclosures. Escrow opened with Michelle Patterson at DOMA.
appliances__c, Dishwasher;Microwave;Free Standing Gas Range;Free Standing Refrigerator;Ice Maker
architectural_style__c, Traditional
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1941
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Bernard Katzmann
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-01-12T19:46:38.000+0000
days_on_market__c, 42
dom__c, 7
ffd_description_pb, Freshly remodeled classic 1940's home with contemporary updates in an excellent Outer Sunset location just one block from Noriega Street and seven blocks to Ocean Beach. Newly landscaped front garden leads to a large tunnel entry with covered skylight. New wide-plank wood flooring, and new contemporary light fixtures throughout.Entry hall opens to a bright living room with a handsome fireplace. The dining area leads to newly remodeled chef's kitchen with quartz counter tops and abundant new cabinetry. New Samsung stainless appliances include a gas range, French door refrigerator with ice maker, and dishwasher. New vented over the range microwave oven. Contemporary lighting and large skylight. Large primary bedroom with garden outlooks. A second bedroom with garden outlooks. Beautifully remodeled bathroom with a large skylight, shower with soaking tub, contemporary tile, new vanity and updated lighting. Recently landscaped rear fenced garden with planting beds and low maintenance turf. Expansive one car garage with additional storage area, with interior access and possible expansion potential. (May accommodate two car tandem parking). Freshly painted interior and exterior. Prime Outer Sunset location just blocks to Ocean Beach, and wonderful Noriega Street restaurants and stores.
district__c, SF District 2
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
electric__c, 220 Volts
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Back Yard;Wood;Fenced;Full
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2023-02-23T11:48:34.000+0000
pba__latitude_pb__c, 37.754819
pba__latitude_property__c, 37.754819
laundry_features__c, Hookups Only
listed_date__c, 2022-09-13
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Michael
pba__listing_agent_lastname__c, Shaw
listing_agent_mls_id__c, 800323
ffd_listingagentname, Michael H Shaw
listing_agent_number__c, 800323
listing_co_agent_mls_id__c, 263622
listing_co_agent_number__c, 263622
listing_co_office_mls_id__c, VANG03
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 1228
listing_office_mls_id__c, VANG03
listing_office_name__c, Vanguard Properties
listing_office_number__c, 1228
pba__listingprice_pb__c, 1200000
pba__listingtype__c, Sale
pba__listing_website__c, http://outersunsetliving.com
pba__longitude_pb__c, -122.500992
lower_level__c, Garage
mls_id__c, 423713982
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Tub w/Shower Over;Tile;Window;Skylight/Solar Tube
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-01-12
original_price__c, 1200000
overall_days_on_market__c, -81460
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener,Garage Facing Front,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-01-19
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-02-22T13:43:18.000+0000
price_per_square_foot__c, 1276.19
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000a6ytJUAQ
roof__c, Bitumen
room_type__c, Kitchen;Living Room;Dining Room;Primary Bathroom;Primary Bedroom;Primary Bedroom 2+
sale_date__c, 2023-02-17
sale_price__c, 1340000
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector
selling_agent_mls_id__c, 804455
selling_agent_number__c, 166014017
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, 1050
size__c, 1050
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 42nd
subdist__c, Outer Sunset
ffd_name, 1706 42nd Avenue, San Francisco, CA, 94122
website_property_type__c, Single Family Home
window_features__c, Dual Pane Partial
pba__yearbuilt_pb__c, 1941
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530568263-1.jpg