meta_query='key:subdist__c;value:Central Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='415648' 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
(
)
)
_yoast_indexnow_last_ping, 1726707502
ffd_listing_title, 1507 35th Avenue, San Francisco, CA, 94122
ffd_mls_id, 424066432
ffd_salesforce_id, a0EUd0000038nY5MAI
num_of_fireplaces__c, 2
num_of_rooms__c, 6
of_units__c, 0
address2__c, 1507 35th Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1507 35th Avenue, San Francisco, CA, 94122
agent_only_remarks__c, 1) Offer date TBD. 2) On supra lockbox, NO appointments or additional call/text notices needed. 3) For disclosures please EMAIL (not texting) listing agent Jason Chan at [email protected]. Disclosure link will be emailed to you once it's ready. 4) For questions, please text Jason at 415.215.1661. 5) For lockbox issues or showing difficulties, please contact Julie Chan via email: [email protected] or via text: 415.672.7988. Email or text preferred. 6) SF purchase agreement preferred, but CAR is okay. 7) Please INCLUDE Contingency Removal form & signing off the cover page of the disclosure packet. 8) Please tell your loan agent NOT TO CALL after your offer is submitted. I will contact them if it's necessary. 9) Pre-sale escrow opened w/ WFG National Title Insurance Company with Kathie Ng. 10) Seller reserves the right to accept, counter, or reject any offer.
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
bath_features__c, Shower Stall(s);Low-Flow Toilet(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1932
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Julie Y Chan
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-09-18T17:47:22.000+0000
days_on_market__c, 0
dom__c, 0
ffd_description_pb, We are excited to present one of the rarest and finest homes in the Avenues - an exquisite example of why Rousseau homes are considered the trophy properties in the area. This magnificent Oliver Rousseau-designed home has been beautifully updated while preserving its stunning architectural details and craftsmanship. It features a sunken living room with soaring ceilings, access to enclosed front balcony, and an original fireplace. The elegant formal dining room boasts period crown moldings, while the oversized center patio and remodeled kitchen with a spacious breakfast nook add to the charm. The top floor also includes a curved hallway, an updated full bath, a half bath, and two generous-sized bedrooms side by side in the back with partial ocean views. Interior stairs lead to the family room or primary suite with additional signature second fireplace, complete with a full bath, walk-in closet, and access to a large deck -perfect for working from home. Ground floor living space is also perfect for a guest suite! The huge garage offers parking for 2+ cars and room for future expansion. Just two blocks from Judah Street MUNI lines & Sunset Boulevard buses, and just a few blocks to Golden Gate Park, and the shops and restaurants on both Noriega and Judah Streets!
district__c, SF District 2
driveway_sidewalks__c, Gated,Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Family Room;Primary Bedroom
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Cathedral Ceiling;Open Beam Ceiling
ffd_lastmodifieddate, 2024-09-19T00:47:04.000+0000
pba__latitude_pb__c, 37.7588517
pba__latitude_property__c, 37.7588517
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2024-09-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jason
pba__listing_agent_lastname__c, Chan
listing_agent_mls_id__c, 802554
ffd_listingagentname, Jason C Chan
listing_agent_number__c, 802554
listing_co_agent_mls_id__c, 807828
listing_co_agent_number__c, 1027382
listing_co_office_mls_id__c, BARBCO
listing_co_office_name__c, BarbCo
listing_co_office_number__c, 28297
listing_office_mls_id__c, BARBCO
listing_office_name__c, BarbCo
listing_office_number__c, 28297
pba__listingprice_pb__c, 1295000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4942869
lower_level__c, Bedroom(s),Full Bath(s),Garage,Primary Bedroom
mls_id__c, 424066432
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Tub;Low-Flow Toilet(s);Double Sinks;Walk-In Closet;Low-Flow Shower(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2024-09-18
open_house_end__c, 2024-09-22T16:00:00.000+0000
open_house_start__c, 2024-09-22T14:00:00.000+0000
original_price__c, 1295000
overall_days_on_market__c, -82075
parking_access__c, Tandem
parking_features__c, Attached,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Covered Patio
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 699.62
pba__propertytype__c, Single Family Residence
ListingId, a0EUd0000038nY5MAI
room_type__c, Storage;Laundry;Kitchen;Living Room;Guest Quarters;Dining Room;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 1851
size__c, 1851
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 35th
subdist__c, Central Sunset
ffd_name, 1507 35th Avenue, San Francisco, CA, 94122
view__c, Ocean
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1932
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530843711-1.jpg
