meta_query='key:subdist__c;value:Outer Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214783' 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, 1627 37th Avenue, San Francisco, CA, 94122
ffd_mls_id, 506133
ffd_salesforce_id, a0E1I00000THjfsUAD
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 1627 37th Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1627 37th Avenue, San Francisco, CA, 94122
agent_only_remarks__c, Offer date on Monday 9/28 by noon. COVID compliant showings, please call Houda at 415-794-346.Before visiting the property, please have each entrant SIGN and RETURN to the listing agent the signed PEAD. Escrow FlNP-0262000458, with Marry Ann Bunnell at Lawyers Title. All offers, if any should have a completely signed disclosures, proof of funds, and if loan, a pre-approval letter.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Freestanding Range;Hood Over Range;ENERGY STAR Qualified Appliances;Freezer
architectural_style__c, Marina
bath_features__c, Remodeled
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 1941
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-09-30
ffd_createddate, 2020-09-16T10:45:57.000+0000
days_on_market__c, 1036
dom__c, 27
ffd_description_pb, This luxurious completely remodeled Marina Style home with ocean views captures the spirit of modern living at its finest, it has been fully renovated and offers unparalleled quality and design.Hallmarks of this home include stately curb appeal and an interior designed with an amazing open concept floor plan.It offers the ultimate in the indoor/outdoor experience and includes new decks, landscaped backyard that are ideal for entertaining.It even has a sand box for child's play! This home boasts 4 beds,2 of which are en-suites and all 4 have access to the magnificently designed outdoor space, 4 full baths. The L/R has character with original architectural details and a peaceful outlook to Sunset Blvd.The stylish D/R opens up to a state of the art kitchen that features high-end appliances, Belmont cabinetry, custom countertops/ backsplash and Circa lighting.The lower level has 2 beds, a F/R, storage space, separate laundry room,1 car garage, internet, electric car wiring and much more!
district__c, SF District 2
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Wood Burning
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-01-25T15:34:35.000+0000
pba__latitude_pb__c, 37.756553
pba__latitude_property__c, 37.756553
laundry_features__c, Inside Room;Washer/Dryer Included
listed_date__c, 2020-09-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Houda
pba__listing_agent_lastname__c, Tanverakul
listing_agent_mls_id__c, 806945
ffd_listingagentname, Houda Tanverakul
listing_agent_number__c, 166017922
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 2295000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.162737thave.com
pba__longitude_pb__c, -122.496318
pba__lotsize_pb__c, 0.07
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 506133
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-09-16
original_price__c, 2295000
overall_days_on_market__c, 148
parking__c, Attached,Garage,Auto Door,Interior Access
parking_access__c, Tandem
parking_features__c, Attached,Garage Door Opener,Interior Access,Tandem Garage,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-10-13
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1008.46
pba__propertytype__c, Single Family Residence
id, a0E1I00000THjfsUAD
room_type__c, Laundry
sale_date__c, 2020-12-04
sale_price__c, 2385000
selling_agent_mls_id__c, 803654
selling_agent_name__c, Butch Haze
selling_agent_number__c, 803654
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, 2365
size__c, 2365
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 37th
subdist__c, Outer Sunset
ffd_name, 1627 37th Avenue, San Francisco, CA, 94122
transportation__c, 1 Block
view__c, Ocean
website_property_type__c, Single Family Home
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/370334-1.jpg
ListingId, a0E1I00000THjfsUAD