meta_query='key:subdist__c;value:Haight Ashbury|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214695' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15734
[post_author] => 4
[post_date] => 2018-11-02 19:54:59
[post_date_gmt] => 2018-11-02 19:54:59
[post_content] => Jimi Hendrix, Janis Joplin, The Grateful Dead. 1968. Victorians, Edwardians, street punks, and skater kids. Everyone has an idea of what the Haight should be. Come discover what it actually is for yourself.
[post_title] => Haight Ashbury
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => haight-ashbury
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 11:28:05
[post_modified_gmt] => 2024-04-09 18:28:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15734
[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, 1140 Page Street, San Francisco, CA, 94117
ffd_mls_id, 505820
ffd_salesforce_id, a0E1I00000THhnQUAT
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 4
address2__c, 1140 Page Street, San Francisco, CA, 94117
pba__address_pb__c, 1140 Page Street, San Francisco, CA, 94117
agent_only_remarks__c, SHOWINGS and PREVIEWS are easy to arrange by appointment Call/Text Trim 415-269-1667 or email @ [email protected] Link to video here: www.1140page.com All COVID documents, as well as our showing instructions, are available in the disclosure packet. https://app.disclosures.io/link/1140-Page-Street-3rovl7p6 I look forward to seeing you and safely showing you and your clients this great home! Condo maps show 1673 sq.ft. draftsman drawings show 1850 sq.ft. The subject street has been designated a slow street during the Covid-19 SIP Protocol.
appliances__c, Dishwasher;Gas Range;Microwave;Refrigerator;Hood Over Range;Built-In Oven
architectural_style__c, Contemporary
bath_features__c, Shower Stall(s);Tub
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 2012
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-09-19
ffd_createddate, 2020-09-11T18:50:27.000+0000
days_on_market__c, 1041
dom__c, 29
ffd_description_pb, Welcome to this stunning Penthouse condominium in a small four-unit luxury building constructed in 2012. Nestled between NoPa and Buena Vista Park, this immaculate property features breathtaking panoramic views and grand open living on 2 levels with an amazing walk-out view terrace. Spacious living & dining rooms open to the gourmet kitchen with caesar-stone countertops, center island, european stainless-steel appliances & designer lighting. Three bedrooms and two bathrooms on one level, including a master retreat with a spa-like bathroom offering a soaking tub with incredible views of the city. Custom touches include audio speakers with Sonos control port, Hardwood flooring, radiant heating system, laundry, built in cabinets & bookcases, 1 car garage parking, a spectacular deeded roof deck with panoramic views of the surrounding city of SF & downtown skyline. Steps to NOPA restaurants & cafes, BV & GG Parks. Easy access to freeway, public transit, and tech shuttle stops.
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway
entry_level__c, 2
external_listing__c, 1
pba__floor__c, 2
pba__floortype_pb__c, Carpet;Wood
hoa_dues__c, 510.33
hoa_fee_includes__c, Management,Maintenance Grounds,Homeowners Insurance,Water
pba__hoafees__c, 510
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 1134-1140 Page St.
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant
ffd_lastmodifieddate, 2022-01-25T15:34:03.000+0000
pba__latitude_pb__c, 37.7721746
pba__latitude_property__c, 37.7721746
laundry_appliances__c, Washer/Dryer,In Closet
laundry_features__c, Laundry Closet;Washer/Dryer Included
listed_date__c, 2020-09-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Trim
pba__listing_agent_lastname__c, Wellbeloved
listing_agent_mls_id__c, 802156
ffd_listingagentname, Tremain T Wellbeloved
listing_agent_number__c, 802156
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12PUI
listing_office_name__c, Compass
listing_office_number__c, 27690
pba__listingprice_pb__c, 2195000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.1140page.com
pba__longitude_pb__c, -122.4396769
pba__lotsize_pb__c, 0
mls_id__c, 505820
main_level__c, Full Bath(s);Bedroom(s)
master_property__c, a0O1I00000AC7jZUAT
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-09-11
original_price__c, 2195000
overall_days_on_market__c, 36
parking_access__c, Side by Side
parking_features__c, Garage Door Opener,Mechanical Lift,Side-by-Side,Garage
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2020-10-10
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1186.49
pba__propertytype__c, Condominium
id, a0E1I00000THhnQUAT
roof__c, Composition
sale_date__c, 2020-10-20
sale_price__c, 2195000
selling_agent_mls_id__c, 810887
selling_agent_name__c, Janeen M. Anderson
selling_agent_number__c, 1048607
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass SF
pba__status__c, Closed
pba__totalarea_pb__c, 1850
size__c, 1850
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Page
subdist__c, Haight Ashbury
ffd_name, 1140 Page Street, San Francisco, CA, 94117
transportation__c, 1 Block
view__c, Park;Panoramic;City Lights;Downtown;San Francisco
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2012
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/370065-1.jpg
ListingId, a0E1I00000THhnQUAT