meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237430' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15729
[post_author] => 4
[post_date] => 2018-11-02 19:54:53
[post_date_gmt] => 2018-11-02 19:54:53
[post_content] => From freeway-bisected loser to urban renaissance pedestrian paradise winner. Sunny. Central. Flat. Where Victorians make friends with modern condos. Great shops, boutiques, and restaurants served by great transit. A San Francisco success story.
[post_title] => Hayes Valley
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => hayes-valley
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 11:31:42
[post_modified_gmt] => 2024-04-09 18:31:42
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15729
[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, 412 Haight 416 Street, San Francisco, CA, 94117
ffd_mls_id, 422662241
ffd_salesforce_id, a0E8W00000WjclPUAR
num_of_rooms__c, 15
of_units__c, 3
address2__c, 412 Haight 416 Street, San Francisco, CA, 94117
pba__address_pb__c, 412 Haight 416 Street, San Francisco, CA, 94117
agent_only_remarks__c, For private showings, contact Gina Blancarte at 415.879.8690 or [email protected] or Edwina Tynan at 415.994.8394 or [email protected]. Disclosures available upon request. Property Website is www.HomeOnHaight.com . Seller has the right to accept or reject any or all offers.
appliances__c, Dishwasher;Gas Water Heater;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator;Varies By Unit
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 9
year_build_text__c, 1890
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Edwina Tynan
pba__contingentdate__c, 2022-06-22
cooling__c, None
ffd_createddate, 2022-05-23T14:46:18.000+0000
days_on_market__c, 422
dom__c, 44
ffd_description_pb, Contractors/Developers & Investors, this VACANT 3 UNIT bldg. is a Victorian beauty. It presents an excellent opp. to purchase an investment in vibrant lower Haight Street. Opps.incl., multifamily rental Income Investment, possible TIC Conversion, reconfiguration, expansion potential, ideal 1031 Exchange replacement property or family compound. 3,750 sq ft per tax records. Unit #412 - 2 bed 1 bath, #414 - 3Bd 1 bath, #416 - 4bed 1BA w/1 loft style bdrm/office off kitchen. 2 large walk-out decks off upper & middle units. All units have access to garden. Lndry rm & storage in basement. Separate gas & electric meters. Character abounds in this historic Victorian, period details, beautiful staircase, high ceilings, stained glass skylight, expansive rms w/ hrdwd floors, beautiful millwork w/ original fireplaces. Improvements & upgrades made by current owners incl. painting, hrdwd floor refinishing & some remodeling of kitchens. Upside opp. w/multiple income streams waiting for your vision!
district__c, SF District 6
external_listing__c, 1
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, None;Gas
interior_features__c, Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2022-08-09T10:49:37.000+0000
pba__latitude_pb__c, 37.772502
pba__latitude_property__c, 37.772502
laundry_features__c, Coin Operated;In Common Area;Washer/Dryer Owned
listed_date__c, 2022-04-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Gina
pba__listing_agent_lastname__c, Blancarte
listing_agent_mls_id__c, 813228
ffd_listingagentname, Gina G Blancarte
listing_agent_number__c, 1060322
listing_co_agent_mls_id__c, 811607
listing_co_agent_number__c, 1052655
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 2458000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.homeonhaight.com/?mls
pba__longitude_pb__c, -122.429181
mls_id__c, 422662241
parkingspaces__c, 0
on_market_date__c, 2022-05-23
original_price__c, 2458000
overall_days_on_market__c, -81226
pba__pendingdate__c, 2022-07-06
price_per_square_foot__c, 569.33
pba__propertytype__c, Triplex
record_id, a0E8W00000WjclPUAR
roof__c, Bitumen;Tar/Gravel;Composition
sale_date__c, 2022-08-05
sale_price__c, 2135000
security_features__c, Security Gate
selling_agent_mls_id__c, 803507
selling_agent_number__c, 803507
selling_co_agent_mls_id__c, 813762
selling_co_agent_number__c, 1062990
selling_co_office_mls_id__c, POLARISR
selling_co_office_name__c, Polaris Realty
selling_co_office_number__c, 27749
selling_office_name__c, Polaris Realty
pba__status__c, Closed
pba__totalarea_pb__c, 3750
size__c, 3750
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Haight
subdist__c, Hayes Valley
ffd_name, 412 Haight 416 Street, San Francisco, CA, 94117
view__c, City;San Francisco;Hills;Varies by Unit
website_property_type__c, Triplex
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1890
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530463820-1.jpg
ListingId, a0E8W00000WjclPUAR