meta_query='key:subdist__c;value:Golden Gate Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='378552' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12173
[post_author] => 4
[post_date] => 2018-10-30 00:43:24
[post_date_gmt] => 2018-10-30 00:43:24
[post_content] => Views, views, and more views. On a clear day, the Farallon Islands poke out of the Pacific and make for a beautiful sunset. Many locals don’t even know Golden Gate Heights is a place, but you know it when you’re there -- above it all, with a view that seems to go on forever.
[post_title] => Golden Gate Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => golden-gate-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 12:19:34
[post_modified_gmt] => 2024-03-19 19:19:34
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12173
[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, 1717066715
ffd_listing_title, 839 Noriega Street, San Francisco, CA, 94122
ffd_mls_id, 424028621
ffd_salesforce_id, a0EUd000001swPqMAI
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 839 Noriega Street, San Francisco, CA, 94122
pba__address_pb__c, 839 Noriega Street, San Francisco, CA, 94122
agent_only_remarks__c, 1) Offers due Thursday 5/9/24 by 1 p.m. 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;Built-In Gas Oven;Free Standing Refrigerator;Gas Cook Top
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1946
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Julie Y Chan
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-04-30T18:47:19.000+0000
days_on_market__c, 30
dom__c, 9
ffd_description_pb, Presenting a sun-drenched detached home in prestigious Golden Gate Heights, boasting captivating panoramic ocean views. Positioned on an expansive lot opposite Grandview Open Space, adjacent to Grandview Park, this residence offers an unrivaled location. Mere steps from the Mosaic Stairway, residents can relish morning hikes to Grandview Park, revealing breathtaking ocean and city views. The top floor showcases a reverse floor plan, featuring a living room adorned with an original fireplace and a spacious dining room at the rear, unveiling vast views of the Sunset District and Pacific Ocean. Additionally, discover a generously updated kitchen with an inviting eat-in area, a full bath, and two bedrooms nestled side by side at the front. Interior stairs descend to the ground floor, presenting a legal family room (or a third bedroom) with double French doors to the rear yard, a wet bar, and a second full bath, alongside a one-car garage with ample storage. Outside, the expansive and meticulously tended terraced backyard offers a serene retreat. With public transit mere blocks away, this remarkable home harmonizes convenience with luxury.
district__c, SF District 2
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Tile;Wood;Simulated Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-05-30T10:49:01.000+0000
pba__latitude_pb__c, 37.7546825
pba__latitude_property__c, 37.7546825
laundry_features__c, In Garage
listed_date__c, 2024-04-30
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.4726123
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage,Street Entrance
mls_id__c, 424028621
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-04-30
original_price__c, 1295000
overall_days_on_market__c, -81934
parking_access__c, Independent
parking_features__c, Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2024-05-09
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-05-29T15:42:24.000+0000
price_per_square_foot__c, 1332.15
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001swPqMAI
sale_date__c, 2024-05-29
sale_price__c, 2250000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, MLSL306402
selling_agent_number__c, 981201260
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Keller Williams Palo Alto
pba__status__c, Closed
pba__totalarea_pb__c, 1689
size__c, 1689
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Noriega
subdist__c, Golden Gate Heights
ffd_name, 839 Noriega Street, San Francisco, CA, 94122
view__c, Ocean
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1946
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530769595-1.jpg