meta_query='key:subdist__c;value:Haight Ashbury|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='375699' 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-11-22 10:15:44
[post_modified_gmt] => 2024-11-22 18:15:44
[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
(
)
)
_yoast_indexnow_last_ping, 1735681004
ffd_listing_title, 1718 Waller Street #B, San Francisco, CA, 94117
ffd_mls_id, 424010401
ffd_salesforce_id, a0EUd000001G0jUMAS
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 4
address2__c, 1718 Waller Street #B, San Francisco, CA, 94117
pba__address_pb__c, 1718 Waller Street #B, San Francisco, CA, 94117
agent_only_remarks__c, Disclosures Link https://app.disclosures.io/link/17141718-Waller-St-1718B-iitp42x8 New TIC Agreement is ready by Nicole Schaefer ,Redwood credit union ,916 541 2641 .Fractional TIC financing available . Pre - Escrow opened #101-10573814 with Marissa Sanchez,Vylla escrow,Inc. 949 517 1136 , seller kindly requested to keep it there .please submit fully signed disclosure package with the offer .Thanks!
appliances__c, Dishwasher;Microwave;Built-In Gas Range;Electric Water Heater;Ice Maker;Built-In Freezer
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1904
pba__city_pb__c, San Francisco
listing_co_agent_name__c, James A Caldwell
pba__contingentdate__c, 2024-03-13
ffd_createddate, 2024-02-26T11:47:07.000+0000
days_on_market__c, 309
dom__c, 32
ffd_description_pb, Welcome to your cozy urban oasis nestled in the heart of the vibrant Haight and Ashbury neighborhood! This charming 1-bedroom, 1-bathroom residence boasts an abundance of natural light and a spacious open floor plan, creating an inviting ambiance from the moment you step inside. The living space provides maximize comfort and functionality, featuring a well-appointed kitchen equipped with modern appliances, ample of counter space and an island with breakfast bar. Perfect for both relaxing evenings and entertaining guests, the living area seamlessly flows into the dining nook, creating a warm and welcoming atmosphere.The in-unit washer and dryer, offers added ease to your daily routine. Step outside to discover the shared backyard, where you can unwind and soak in the sunshine. Located in a lively and eclectic neighborhood, this residence offers unparalleled access to an array of cafes, restaurants, boutiques, and cultural attractions. From iconic landmarks to hidden gems, there's always something new to explore just steps from your doorstep.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 250
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas
ffd_lastmodifieddate, 2024-04-11T10:47:39.000+0000
pba__latitude_pb__c, 37.768629
pba__latitude_property__c, 37.768629
laundry_features__c, Laundry Closet;Washer Included;Dryer Included
listed_date__c, 2024-01-31
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Shivani
pba__listing_agent_lastname__c, Desai
listing_agent_mls_id__c, 813219
ffd_listingagentname, Shivani Desai
listing_agent_number__c, 1060292
listing_co_agent_mls_id__c, 802434
listing_co_agent_number__c, 802434
listing_co_office_mls_id__c, COMP12
listing_co_office_name__c, Compass
listing_co_office_number__c, 28739
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 28739
pba__listingprice_pb__c, 570000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.asteroommls.com/pviewer?hideleadgen=1&token=tTTcCJgelU6AkxmxwKKcRg
pba__longitude_pb__c, -122.452083
mls_id__c, 424010401
master_bathroom_features__c, Shower Stall(s);Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2024-02-26
original_price__c, 570000
overall_days_on_market__c, -81870
pba__pendingdate__c, 2024-03-29
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 876.92
pba__propertytype__c, Tenancy In Common
ListingId, a0EUd000001G0jUMAS
room_type__c, Living Room;Primary Bedroom
sale_date__c, 2024-04-10
sale_price__c, 570000
security_features__c, Security Gate
selling_agent_mls_id__c, 813927
selling_agent_number__c, 1063399
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, 650
size__c, 650
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Waller
subdist__c, Haight Ashbury
ffd_name, 1718 Waller Street #B, San Francisco, CA, 94117
website_property_type__c, Tenancy In Common
pba__yearbuilt_pb__c, 1904
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530734543-1.jpg