meta_query='key:subdist__c;value:Central Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='382719' 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, 1735681793
ffd_listing_title, 2850 Noriega Street, San Francisco, CA, 94122
ffd_mls_id, 424042998
ffd_salesforce_id, a0EUd000002MH4IMAW
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 2850 Noriega Street, San Francisco, CA, 94122
pba__address_pb__c, 2850 Noriega Street, San Francisco, CA, 94122
agent_only_remarks__c, 1) Offers due Wednesday 7/3/2024 by 1 p.m. 2) On supra lockbox with restricted hours. Show from 6 a.m. to 10 p.m. ONLY. 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, Tub w/Shower Over;Low-Flow Toilet(s);Low-Flow Shower(s)
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1940
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Julie Y Chan
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-06-19T20:47:32.000+0000
days_on_market__c, 195
dom__c, 14
ffd_description_pb, Newly remodeled Central Sunset ocean view home, located on tree-lined street and just steps from the vibrant shops and restaurants on Noriega Street, Farmers Market across the street, Ocean Beach, Golden Gate Park, both private & public schools within several blocks away, Sunset Recreation Centers, West Sunset Playground, Sunset Reservoir, and public transit. This extensively remodeled home features designer finishes throughout and is detached on three sides, allowing abundant natural sunlight. The top level includes a spacious living room with ocean views, an open kitchen and dining area with ocean views, and direct stairway access to the yard. The primary suite has a full bath, and a second bedroom plus a full bath with a stackable washer and dryer complete this level. The ground floor offers a third bedroom, a family room with a wet bar, and a full bath. The spacious garage provides parking for one car and ample storage. Enjoy watching the sunset over the Pacific Ocean from your living room or during dinner. The private side yard with a patio is perfect for entertaining!
district__c, SF District 2
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-07-25T10:49:19.000+0000
pba__latitude_pb__c, 37.75364
pba__latitude_property__c, 37.75364
laundry_features__c, In Garage;Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2024-06-19
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.4945126
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage
mls_id__c, 424042998
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Low-Flow Toilet(s);Low-Flow Shower(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-06-19
original_price__c, 1295000
overall_days_on_market__c, -81984
parking_access__c, Independent
parking_features__c, Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2024-07-03
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-07-24T16:45:54.000+0000
price_per_square_foot__c, 1040.23
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000002MH4IMAW
sale_date__c, 2024-07-24
sale_price__c, 1810000
security_features__c, Smoke Detector;Carbon Mon Detector;Double Strapped Water Heater
selling_agent_mls_id__c, 806718
selling_agent_number__c, 166017501
selling_co_agent_mls_id__c, 818732
selling_co_agent_number__c, 1077445
selling_co_office_mls_id__c, BRAVA
selling_co_office_name__c, Brava Real Estate
selling_co_office_number__c, 28638
selling_office_name__c, Brava Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1740
size__c, 1740
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Noriega
subdist__c, Central Sunset
ffd_name, 2850 Noriega Street, San Francisco, CA, 94122
view__c, Ocean
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/530797423-1.jpg