meta_query='key:subdist__c;value:Downtown|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212106' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70672
[post_author] => 4
[post_date] => 2018-11-30 20:30:47
[post_date_gmt] => 2018-11-30 20:30:47
[post_content] => Not quite as glamorous as the Financial District, not quite as tough as the Tenderloin. Midrise mixed-use buildings dominate in the district that includes tourist-heavy destinations and world-class shopping district Union Square.
[post_title] => Downtown
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => downtown
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 11:10:22
[post_modified_gmt] => 2024-04-09 18:10:22
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70672
[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, 1299 Bush Street #602, San Francisco, CA, 94109
ffd_mls_id, 497273
ffd_salesforce_id, a0E1I00000SlU6bUAF
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 27
address2__c, 1299 Bush Street #602, San Francisco, CA, 94109
pba__address_pb__c, 1299 Bush Street #602, San Francisco, CA, 94109
agent_only_remarks__c, Online virtual tour available at https://my.matterport.com/show/?m=LQyFbbQ9HtU. Live virtual tours available via Facebook/Facetime by appointment. Email [email protected] for more information. Showings available by appointment under state and local guidelines for qualified prospects. All visitors to execute the PEAD addendum. Staged photos are artist renderings.
appliances__c, Dishwasher;Gas Range;Disposal;Refrigerator;Hood Over Range;Cooktop Stove
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 2009
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Marcus A Lee
pba__contingentdate__c, 2020-05-13
ffd_createddate, 2020-05-01T20:46:14.000+0000
days_on_market__c, 1174
dom__c, 26
ffd_description_pb, Located in the AXIS, a boutique 27-unit elevator building in Lower Nob Hill, 1299 Bush St. #602 is a stunning, modern 1 BD 1 BA corner-orientation condominium with an efficient open concept floor plan and sophisticated contemporary design touches. Featuring dramatic floor-to-ceiling window lines, mahogany floors, and extra-height ceilings, the home offers a well-appointed chef's kitchen with best-in-class stainless steel appliances; a large adjoining master bedroom with impressive city views; and a spa-like common full bath with contemporary finishes. Take advantage of the building's scenic rooftop terrace and grilling area, and enjoy convenient Polk Street shopping and dining, Whole Foods, Trader Joe's, tech buses, and public transportation. With an almost perfect Walk Score of 99, all daily conveniences and a wide variety of shopping and dining are close at hand, and all public transit options and freeways are easily accessible - Transit Score of 100. www.Axis602.com
district__c, SF District 8
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 6
external_listing__c, 1
pba__floor__c, 6
pba__floortype_pb__c, Wood
hoa_dues__c, 777.01
hoa_fee_includes__c, Management,Maintenance Exterior,Trash,Maintenance Grounds,Water
pba__hoafees__c, 777
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:21:33.000+0000
pba__latitude_pb__c, 37.788708
pba__latitude_property__c, 37.788708
laundry_appliances__c, Washer/Dryer,In Closet
laundry_features__c, Laundry Closet;Washer/Dryer Included
listed_date__c, 2020-05-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Todd
pba__listing_agent_lastname__c, Montgomery
listing_agent_mls_id__c, 807753
ffd_listingagentname, Todd Montgomery
listing_agent_number__c, 1025356
listing_co_agent_mls_id__c, 804756
listing_co_agent_number__c, 166014430
listing_co_office_mls_id__c, COMP47
listing_co_office_name__c, Compass
listing_co_office_number__c, 28243
listing_office_mls_id__c, COMP47
listing_office_name__c, Compass
listing_office_number__c, 28243
pba__listingprice_pb__c, 799000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=LQyFbbQ9HtU&brand=0
pba__longitude_pb__c, -122.418408
pba__lotsize_pb__c, 0
mls_id__c, 497273
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_property__c, a0O1I000001Vi2KUAS
monthly_parking_fees__c, 49.66
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-05-01
original_price__c, 799000
overall_days_on_market__c, 60
parking_access__c, Side by Side
parking_features__c, Attached,Mechanical Lift,Private,Side-by-Side,Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2020-05-27
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1092.7
pba__propertytype__c, Condominium
id, a0E1I00000SlU6bUAF
sale_date__c, 2020-06-22
sale_price__c, 778000
selling_agent_mls_id__c, 810530
selling_agent_name__c, Francis E. Somsel
selling_agent_number__c, 1046703
selling_co_agent_mls_id__c, 814919
selling_co_agent_name__c, Gerardo A. Chirichigno
selling_co_agent_number__c, 1069142
selling_co_office_mls_id__c, COMP3
selling_co_office_name__c, Compass
selling_co_office_number__c, 27342
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 712
size__c, 712
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Bush
subdist__c, Downtown
ffd_name, 1299 Bush Street #602, San Francisco, CA, 94109
transportation__c, 1 Block
unit_number__c, 602
view__c, City Lights;San Francisco
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2009
pba__postalcode_pb__c, 94109
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/362590-1.jpg
ListingId, a0E1I00000SlU6bUAF