meta_query='key:subdist__c;value:Twin Peaks|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='335594' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15732
[post_author] => 4
[post_date] => 2018-11-02 19:54:57
[post_date_gmt] => 2018-11-02 19:54:57
[post_content] => San Francisco's highest point was developed beginning in the 1960s. Mid-century construction, utilitarian buildings, and jaw-dropping views of downtown and the East Bay when the wind and fog relent.
[post_title] => Twin Peaks
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => twin-peaks
[to_ping] =>
[pinged] =>
[post_modified] => 2023-08-21 10:41:08
[post_modified_gmt] => 2023-08-21 17:41:08
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15732
[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, 5 Burnett North Avenue #3, San Francisco, CA, 94131
ffd_mls_id, 423755589
ffd_salesforce_id, a0E8W00000bkuI8UAI
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 20
address2__c, 5 Burnett North Avenue #3, San Francisco, CA, 94131
pba__address_pb__c, 5 Burnett North Avenue #3, San Francisco, CA, 94131
agent_only_remarks__c, Offer Reviewed As They Come. Pre-Escrow opened with Janette Marcelo at Old Republic Title. Easy to show, contact Marc or Mark. **The HOA Provides Earthquake Insurance. Disclosure packet available at: https://bit.ly/3q0hD8P
appliances__c, Dishwasher;Free Standing Refrigerator;Wine Refrigerator;Double Oven;Built-In Electric Range
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 0
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Mark N Shumway
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-07-20T19:47:53.000+0000
days_on_market__c, 70
dom__c, 54
ffd_description_pb, Views Views Views! Are you looking for luxury and sophistication? Welcome to your dream home in the heart of San Francisco. This large 3 bedroom 2.5 bath two-level home is for you. large windows provide an abundance of natural light and amazing panoramic views of Downtown SF from both levels. Perfect for entertaining guests throughout the large 1st level that combines your private deck, living area, dining room, kitchen, and powder room. The spacious updated kitchen includes Quartz countertops and all new stainless steel appliances, including a double oven and wine fridge. The beautiful circular staircase leads to the second level where you find all 3 large bedrooms consisting of an expansive primary en suite with plenty of room for your home office, two additional bedrooms, and 2nd full bath. There is also a second fireplace and private terrace on this level. This condo has the feel of a single family home with a private gated entrance. Another cool part... Our seller spent her career as a Pan Am flight attendant and was the original owner of this hillside land before it was developed. This home was custom built by her and has been lovingly maintained since. Many custom features throughout! And a 1 car garage. Close to Noe Valley, Cole Valley, and the Castro. It's a must see!
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Wood Burning
hoa_fee_includes__c, Common Areas,Maintenance Grounds,Sewer,Trash,Water
pba__hoafees__c, 1316
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Burnett Terrace Condominiums
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
interior_features__c, Skylight(s);Cathedral Ceiling
ffd_lastmodifieddate, 2023-09-28T10:46:41.000+0000
pba__latitude_pb__c, 37.756832
pba__latitude_property__c, 37.756832
laundry_features__c, Laundry Closet;Washer Included;Dryer Included
listed_date__c, 2023-04-04
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Marc
pba__listing_agent_lastname__c, Dickow
listing_agent_mls_id__c, 807516
ffd_listingagentname, Marc Dickow
listing_agent_number__c, 1020348
listing_co_agent_mls_id__c, 811167
listing_co_agent_number__c, 1050184
listing_co_office_mls_id__c, CORE7
listing_co_office_name__c, Core7 Real Estate
listing_co_office_number__c, 25190
listing_office_mls_id__c, CORE7
listing_office_name__c, Core7 Real Estate
listing_office_number__c, 25190
pba__listingprice_pb__c, 1599000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.444568
mls_id__c, 423755589
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room
master_property__c, a0O8W00000IJIdiUAH
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-07-20
open_house_end__c, 2023-10-01T15:00:00.000+0000
open_house_start__c, 2023-10-01T13:00:00.000+0000
original_price__c, 1625000
overall_days_on_market__c, -81649
parking_access__c, Side by Side
parking_features__c, Attached,Garage Door Opener,Side-by-Side
parking_type__c, On Site - Mapped (Condo Only)
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, 741.31
pba__propertytype__c, Condominium
ListingId, a0E8W00000bkuI8UAI
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, 2157
size__c, 2157
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Burnett
subdist__c, Twin Peaks
ffd_name, 5 Burnett North Avenue #3, San Francisco, CA, 94131
view__c, City;City Lights;Bay;Downtown;Bay Bridge;San Francisco;Bridges
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530649596_e2414724-8aa9-4158-89a1-770269521b20.jpg
_wp_old_slug, 5-burnett-avenue-3-san-francisco-ca-94131
