meta_query='key:subdist__c;value:Central Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237201' 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-03-19 12:20:19
[post_modified_gmt] => 2024-03-19 19:20:19
[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
(
)
)
ffd_listing_title, 1750 33rd Avenue, San Francisco, CA, 94122
ffd_mls_id, 422666459
ffd_salesforce_id, a0E8W00000XihGXUAZ
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 1750 33rd Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1750 33rd Avenue, San Francisco, CA, 94122
agent_only_remarks__c, Offer Date: Thursday, June 30 @ 10:00 AM. Please, no preemptives per seller instruction. Use SFAR Purchase Agreement. Pre-escrow #3652200665, Barbara Jimenez, Chicago Title. Seller reserves the right to accept, reject and counter any offers. Questions? Contact Kelly Quon, 415.244.1798, [email protected].
appliances__c, Dishwasher;Microwave;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
bath_features__c, Shower Stall(s);Tub;Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1940
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Sabrina Gee-Shin
pba__contingentdate__c, 2022-06-30
ffd_createddate, 2022-06-17T10:51:13.000+0000
days_on_market__c, 397
dom__c, 14
ffd_description_pb, Welcome to 1750 33rd Avenue! This beautiful Central Sunset home has 2 bedrooms, 1 bath on the main level with internal stairs leading to the bonus room and half bath on the garden level. The home features architectural charm, great natural light, refinished hardwood floors, formal dining room, wood burning fireplace, and spacious bedrooms. Recent improvements include a new roof and sewer lateral. The roomy garage fits one car and has an abundance of storage. The driveway serves as a convenient extra parking space. A large fenced yard and deck is a great place to relax, entertain, BBQ or garden. Conveniently located near Noriega shopping and restaurants including Safeway, Devil's Teeth Baking Company, Sunset Reservoir Brewing Company, Polly Ann Ice Cream, Sushi Genki, Gus's Community Market, Sunday's Outer Sunset Farmer's Market. Easy access to Sunset Boulevard, 19th Avenue and Highways 1 & 280.
district__c, SF District 2
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Wood
fireplace_features__c, Wood Burning
pba__floortype_pb__c, Tile;Vinyl;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-07-13T17:13:20.000+0000
pba__latitude_pb__c, 37.7544927
pba__latitude_property__c, 37.7544927
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2022-06-05
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Kelly
pba__listing_agent_lastname__c, Quon Lutz
listing_agent_mls_id__c, 810315
ffd_listingagentname, Kelly Quon Lutz
listing_agent_number__c, 1045621
listing_co_agent_mls_id__c, 804986
listing_co_agent_number__c, 166014733
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, 1050000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.centralsunsetcharm.com/unbranded
pba__longitude_pb__c, -122.4913104
lower_level__c, Family Room,Garage,Street Entrance
mls_id__c, 422666459
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, 2022-06-17
original_price__c, 1050000
overall_days_on_market__c, -81251
parking_access__c, Independent
parking_features__c, Attached,Covered,Enclosed,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2022-07-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1217.39
pba__propertytype__c, Single Family Residence
record_id, a0E8W00000XihGXUAZ
roof__c, Bitumen;Shingle
room_type__c, Bonus Room;Kitchen;Living Room;Dining Room
sale_date__c, 2022-07-26
sale_price__c, 1400000
security_features__c, Smoke Detector;Security Gate;Unguarded Gate;Carbon Mon Detector;Window Security Bars
selling_agent_mls_id__c, 805604
selling_agent_number__c, 721509295
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Polaris Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1150
size__c, 1150
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 33rd
subdist__c, Central Sunset
ffd_name, 1750 33rd Avenue, San Francisco, CA, 94122
view__c, Ocean;Water
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/530478755-1.jpg
ListingId, a0E8W00000XihGXUAZ