meta_query='key:subdist__c;value:Central Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='322607' 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, 1647 33rd Avenue, San Francisco, CA, 94122
ffd_mls_id, 422688821
ffd_salesforce_id, a0E8W00000YYcUIUA1
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 1647 33rd Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1647 33rd Avenue, San Francisco, CA, 94122
agent_only_remarks__c, The property is tenant occupied, deliver subject to Tenant's right. Please contact Rachel at (415) 867-8815 for showing and offer details. Seller reserves the right to accept, counter/reject any offers.
appliances__c, Dishwasher;Microwave;Free Standing Gas Range;Free Standing Refrigerator
bath_features__c, Shower Stall(s);Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1940
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-12-16
ffd_createddate, 2022-08-21T19:46:10.000+0000
days_on_market__c, 332
dom__c, 132
ffd_description_pb, This beautiful tunnel entrance home features spectacular sunset and ocean views from both levels & garden. It has 3 bedrooms, 2 baths, while being located in the highly desirable Central Sunset neighborhood near the Noriega Street corridor. The main level is built around a reverse floor plan utilizing hard wood floors and crown molding throughout, showcasing the panoramic view of the ocean from the living and formal dining rooms. Updated kitchen, two spacious bedrooms, and a full bathroom. The lower level comes with a sitting room, and is finished by a gracious master bedroom overlooking the ocean and garden, and a stylish bathroom. One car garage with additional parking at the driveway. Within walking distance from public transit, shops, Safeway, restaurants, recreation parks, library, and top-rated schools. Very convenient for visiting Golden Gate Park, Stonestown Galleria, State University, and Ocean Beach. This is a great home in a prime location!
district__c, SF District 2
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Carpet;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-07-13T17:33:37.000+0000
pba__latitude_pb__c, 37.7564021
pba__latitude_property__c, 37.7564021
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2022-08-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Rachel
pba__listing_agent_lastname__c, Kwok
listing_agent_mls_id__c, 804783
ffd_listingagentname, Rachel L Kwok
listing_agent_number__c, 166014461
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, 1395000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/751516639
pba__longitude_pb__c, -122.4919556
lower_level__c, Full Bath(s),Garage,Primary Bedroom,Street Entrance
mls_id__c, 422688821
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-08-21
original_price__c, 1495000
overall_days_on_market__c, -81316
parking_access__c, Tandem
parking_features__c, Attached,Covered,Garage Facing Front
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2023-01-03
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 668.84
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000YYcUIUA1
room_type__c, Kitchen;Living Room;Dining Room;Primary Bathroom;Primary Bedroom
sale_date__c, 2023-01-10
sale_price__c, 1335000
security_features__c, Security Gate
selling_agent_mls_id__c, 810567
selling_agent_number__c, 1047041
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sage Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1996
size__c, 1996
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 33rd
subdist__c, Central Sunset
ffd_name, 1647 33rd Avenue, San Francisco, CA, 94122
view__c, Ocean;Panoramic
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Bay Window(s)
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/530516797-1.jpg
