meta_query='key:subdist__c;value:Central Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='379604' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12160
[post_author] => 4
[post_date] => 2018-10-29 19:47:38
[post_date_gmt] => 2018-10-29 19:47:38
[post_content] => Proximity to parks, room to roam in the bigger-than-some-SF-neighborhoods yards, and lots of great eateries and local haunts. Downtown is a quick (and probably crowded) N-Judah ride away, and car commuters can hop on 19th Avenue to head south. Yes, there’s more fog than on the east side of town, but that keeps things cool and comfy.
[post_title] => Central Sunset
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => central-sunset
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-07 23:32:48
[post_modified_gmt] => 2024-11-08 07:32:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12160
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
_yoast_indexnow_last_ping, 1735681096
ffd_listing_title, 1827 33rd Avenue, San Francisco, CA, 94122
ffd_mls_id, 424005944
ffd_salesforce_id, a0EUd000001OEKfMAO
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 1827 33rd Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1827 33rd Avenue, San Francisco, CA, 94122
agent_only_remarks__c, $1,208,000 is the MINIMUM opening bid at Probate Court Hearing. Probate Court Hearing Wed, 5/29/24 at 9am -400 McAllister Street Room 204. All overbidders must attend hearing in order to bid. All overbidders MUST have cashier's check in the amount of $120,800 to bid in person only. Cashier check must be payable to Old Republic Title company, 2566 Ocean Ave, Escrow Officer Christine Lim. Any and all overbidders must sign seller disclosure package and MANDATORY ADDENDA to bid. There are NO contingencies allowed for purchase at the Probate Court. VACANT HOME with SUPRA lockbox show 24/7 access! Open for Broker Tours: 3/12, 3/19, 3/26, 4/2, 4/9, 4/16, 4/23, 4/30, 5/7, 5/14, 5/21, 5/28. Open Saturday & Sunday: 3/9, 3/10, 3/16, 3/17 and 5/19 prior to Court Hearing. All disclosure request by EMAIL ONLY. Ground floor living area is unwarranted, and nonconforming, unknown if downstairs area is legal living space. Buyer should investigate to their satisfaction before making any offer or removing any inspection contingency. Seller reserves the right to reject any offer.
architectural_style__c, Traditional
bath_features__c, Shower Stall(s);Tub;Tile
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, Tim Hawko
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-03-08T18:46:55.000+0000
days_on_market__c, 298
dom__c, 82
ffd_description_pb, Probate Court Hearing is set for 5/29/24 at 9am. Extraordinary Opportunity in the Sunset! Fixer Upper home located just a half block to the thriving activity of Noriega Street. This tunnel entrance home is a GOLDEN OPPORTUNITY for the contractor and savvy investor alike. Do you like views? FABULOUS OCEAN VIEWS from both rear bedrooms with UNPARALLELED SUNSETS. This residence has a LIGHT FILLED LIVING ROOM with fireplace, plaster crown molding and arched entryways. Formal dining room opens to an EAT-IN KITCHEN with a skylight. Restoring the bathroom will provide a sanctuary to stay healthy and well balanced. The bathroom has a shower, tub, dressing area and is EN-SUITE TO THE PRIMARY BEDROOM. Both bedrooms are a generous size and the sunroom is also of large scale. The lower living area looks onto the rear yard. This home is on a DEEP LOT WITH A LARGE YARD. This home has a 1-car garage and EXPANSION POTENTIAL. Buy now so you won't be sorry later.
district__c, SF District 2
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Decorative Only
pba__floortype_pb__c, Laminate
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2024-06-12T10:47:15.000+0000
pba__latitude_pb__c, 37.753
pba__latitude_property__c, 37.753
laundry_features__c, In Garage
listed_date__c, 2024-03-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Kathleen
pba__listing_agent_lastname__c, Tostanoski
listing_agent_mls_id__c, 810040
ffd_listingagentname, Katie A Tostanoski
listing_agent_number__c, 1044436
listing_co_agent_mls_id__c, 378394
listing_co_agent_number__c, 378394
listing_co_office_mls_id__c, PKNO
listing_co_office_name__c, Park North Real Estate
listing_co_office_number__c, 24343
listing_office_mls_id__c, PKNO
listing_office_name__c, Park North Real Estate
listing_office_number__c, 24343
pba__listingprice_pb__c, 1208000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.1827-33rdave.com/mls
pba__longitude_pb__c, -122.491764
lower_level__c, Family Room,Street Entrance
mls_id__c, 424005944
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, 2024-03-08
original_price__c, 788000
overall_days_on_market__c, -81881
parking_access__c, Independent
parking_features__c, Attached,Garage Facing Front
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2024-05-29
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-06-11T20:24:35.000+0000
price_per_square_foot__c, 663.59
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001OEKfMAO
room_type__c, Bonus Room;Sun Room;Kitchen;Living Room;Dining Room;Primary Bedroom
sale_date__c, 2024-06-11
sale_price__c, 1150000
security_features__c, Security Gate
selling_agent_mls_id__c, 807882
selling_agent_number__c, 1028110
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, 1733
size__c, 1733
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 33rd
subdist__c, Central Sunset
ffd_name, 1827 33rd Avenue, San Francisco, CA, 94122
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/530741972-1.jpg