meta_query='key:subdist__c;value:Twin Peaks|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217844' 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-10-31 09:39:01
[post_modified_gmt] => 2023-10-31 16:39:01
[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, 1 Burnett North Avenue #9, San Francisco, CA, 94131
ffd_mls_id, 421528617
ffd_salesforce_id, a0E1I00000Tx5JMUAZ
num_of_fireplaces__c, 2
num_of_rooms__c, 6
of_units__c, 20
address2__c, 1 Burnett North Avenue #9, San Francisco, CA, 94131
pba__address_pb__c, 1 Burnett North Avenue #9, San Francisco, CA, 94131
agent_only_remarks__c, **Offers will be reviewed on Friday, April 2 at 11am. Please email offers to [email protected] Vacant and easy to show by appointment only. View the Virtual Tour here: http://bit.ly/LifeOnTop See the property website here: www.twinpeakscityviews.com Please schedule all showings through Calendly here: https://calendly.com/mpowerproperties/1-burnett-ave-n-9-showings Please have buyer view virtual tour and email a signed CAR Form PEAD prior to all showings. Offer date to be TBD after the first weekend showings. Escrow opened with Janette Marcelo at Old Republic Title. NOTE: The legal address is 1 Burnett Ave #9, however, the mailing and GPS address is 3 Burnett Ave North #3. This condo is located in the building marked 3. Disclosures linked to MLS. Staged and shows beautifully. **Earthquake Insurance provided by the HOA
appliances__c, Dishwasher;Disposal;Built-In Gas Range;Built-In Gas Oven;ENERGY STAR Qualified Appliances;Double Oven;Ice Maker;Gas Cook Top
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Tub;Tile;Low-Flow Toilet(s);Jetted Tub;Granite
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1983
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Marc Dickow
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2021-03-23T12:44:20.000+0000
days_on_market__c, 849
dom__c, 14
ffd_description_pb, Views Views Views! Are you looking for luxury and sophistication? This large 3 bedroom 2.5 bath two-level home is for you. 1 car garage parking. Panoramic views of Downtown SF. Perfect for entertaining guests throughout the large downstairs living area, dining room and kitchen. Custom built cabinetry, shelving, and recessed picture lighting. Refinished hardwood flooring throughout. Large beautiful Travertine fireplace and hearth. A spacious kitchen with Quartz counter tops, subway backsplash tiles, a new Wolf gas stovetop and new double oven. Circular staircase to the second level where you find all 3 large bedrooms consisting of an expansive master suite and two additional bedrooms and 2nd full bath. There is also a second fireplace and private terrace on this level. Built in bookcases throughout. This condo has the feel of a single family home with a private gated entrance. No stairs to the front door. Many custom features throughout! It's a must see!
district__c, SF District 5
driveway_sidewalks__c, Shared Driveway
electric__c, 220 Volts,220 Volts in Laundry
entry_level__c, 0
exterior_features__c, Balcony;Entry Gate
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning;Master Bedroom
pba__floortype_pb__c, Carpet;Wood
hoa_fee_includes__c, Common Areas,Earthquake Insurance,Insurance,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Trash,Water
pba__hoafees__c, 893
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Burnett Terrace
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T15:47:50.000+0000
pba__latitude_pb__c, 37.7570083
pba__latitude_property__c, 37.7570083
laundry_features__c, Laundry Closet;Washer Included;Dryer Included
listed_date__c, 2020-12-30
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Mark
pba__listing_agent_lastname__c, Shumway
listing_agent_mls_id__c, 811167
ffd_listingagentname, Mark N Shumway
listing_agent_number__c, 1050184
listing_co_agent_mls_id__c, 807516
listing_co_agent_number__c, 1020348
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, 1699000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=4TJF5DPabQg&brand=0
pba__longitude_pb__c, -122.4449
lower_level__c, Dining Room,Garage,Kitchen,Living Room,Partial Bath(s)
mls_id__c, 421528617
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Shower Stall(s);Tub;Tile;Jetted Tub;Granite
master_property__c, a0O1I00000CFQXAUA5
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-03-22
original_price__c, 1699000
overall_days_on_market__c, 254
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Guest Parking Available,Interior Access
parking_type__c, On Site - Mapped (Condo Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2021-04-05
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 834.49
pba__propertytype__c, Condominium
id, a0E1I00000Tx5JMUAZ
road_surface_type__c, Asphalt
sale_date__c, 2021-04-30
sale_price__c, 1800000
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector
selling_agent_mls_id__c, 804756
selling_agent_number__c, 166014430
selling_co_agent_mls_id__c, 807753
selling_co_agent_number__c, 1025356
selling_co_office_mls_id__c, COMP47
selling_co_office_name__c, Compass
selling_co_office_number__c, 28243
selling_office_name__c, Compass
pba__status__c, Closed
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, 1 Burnett North Avenue #9, San Francisco, CA, 94131
view__c, City;Panoramic;City Lights;Bay;Water;Downtown;San Francisco;Golden Gate Bridge;Twin Peaks;Bridges
website_property_type__c, Condominium
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1983
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530204203-1.jpg
ListingId, a0E1I00000Tx5JMUAZ