meta_query='key:subdist__c;value:Golden Gate Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='216188' 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
(
)
)
ffd_listing_title, 500 Noriega Street, San Francisco, CA, 94122
ffd_mls_id, 510761
ffd_salesforce_id, a0E1I00000Tl8znUAB
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
address2__c, 500 Noriega Street, San Francisco, CA, 94122
pba__address_pb__c, 500 Noriega Street, San Francisco, CA, 94122
agent_only_remarks__c, Easy to show. Please call Heidi at 4150722-2076.It really is an absolutely beautiful home with much more details than I could describe.
appliances__c, Dishwasher;Gas Range;Disposal;Refrigerator;Hood Over Range
bath_features__c, Tub w/Shower Over;Shower Stall(s);Remodeled;Bidet
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1941
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-12-24
ffd_createddate, 2020-12-05T20:46:11.000+0000
days_on_market__c, 956
dom__c, 45
ffd_description_pb, Absolutely stunning panoramic view home in Golden Gate Heights combines beauty, comfort and style. The spacious living room has gorgeous panoramic views all the way to the Golden Gate Bridge and beyond and exquisite details. The formal dining room has the same fabulous views and is perfect for entertaining. The fully-equipped kitchen with panoramic views has a great lay-out with new high-end s/s appliances and a nice breakfast bar.There are 3 bedrooms and 2 baths. The big master suite has a sitting area and the adjacent master bath has great travertine tiles, 2 sinks and a bidet.The 2nd bedroom has a view as well and the 3rd bedroom accesses a balcony.The 2nd bathroom with travertine tiles has a shower over a jacuzzi tub.Hardwood floors throughout add elegance and warmth to this executive-style home. A 2 car s/s garage, serene side yard and an architecturally beautiful exterior make this a perfect home.
district__c, SF District 2
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room;Gas Piped
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:40:47.000+0000
pba__latitude_pb__c, 37.7554015
pba__latitude_property__c, 37.7554015
laundry_features__c, Laundry Closet;Washer/Dryer Included
listed_date__c, 2020-12-05
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Heidi
pba__listing_agent_lastname__c, Mueller
listing_agent_mls_id__c, 263645
ffd_listingagentname, Heidi Mueller
listing_agent_number__c, 263645
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, SANF
listing_office_name__c, Engel & Voelkers San Francisco
listing_office_number__c, 25914
pba__listingprice_pb__c, 2450000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.500noriega.com
pba__longitude_pb__c, -122.4691997
pba__lotsize_pb__c, 0.1
mls_id__c, 510761
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-12-05
original_price__c, 2850000
overall_days_on_market__c, 90
parking__c, Attached,Garage,Auto Door
parking_features__c, Attached,Garage Door Opener,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-01-19
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
id, a0E1I00000Tl8znUAB
sale_date__c, 2021-01-22
sale_price__c, 2250000
selling_agent_mls_id__c, 810564
selling_agent_number__c, 1047032
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Noriega
subdist__c, Golden Gate Heights
ffd_name, 500 Noriega Street, San Francisco, CA, 94122
transportation__c, 4+ Blocks
view__c, Panoramic;Downtown;San Francisco;Golden Gate Bridge;Mt Tamalpais
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1941
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/374499-1.jpg
ListingId, a0E1I00000Tl8znUAB