meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='219754' 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-11-25 11:19:58
[post_modified_gmt] => 2024-11-25 19:19:58
[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, 333 Haight Street #2, San Francisco, CA, 94102
ffd_mls_id, 421569195
ffd_salesforce_id, a0E1I00000UUfqOUAT
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 4
address2__c, 333 Haight Street #2, San Francisco, CA, 94102
pba__address_pb__c, 333 Haight Street #2, San Francisco, CA, 94102
agent_only_remarks__c, HUGE price modification. Great value for a 3bd/2ba/1pkg close to 1400 sq ft. Unit shows well, no need to preview. Deceiving from the street, must see inside to appreciate. 4 car s/s garage in rear of bldg on Laussat Street.1 of 2 TIC units still available at 333 Haight St. Multiple units may be required to close to retire loan. #1 and #4 currently in escrow. 2 owners in partnership are CA licensed realtors. Markoff Report of rear bldg repairs completed in Aug 2020. All energy/water conservation to be completed prior to COE. Low maintenance building and well maintained. No OMI, No Ellis. No HOA dues collected,current partners pay for expenses/repairs as needed as they go. Great neighbors, great location. Please follow offer instructions on Discl iO. New Andy Sirkin TIC Agreement in place. MUST have at least 24hr notice to show, text Debra at (415)602-4575. All visitors to comply with COVID safety recommendations. Please allow at least 3 day response time. Sellers have varied schedules. Escrow opened with Fidelity National Title, Sylvia Wong. Sellers reserve the right to accept or reject any offer. Offer instructions on Discl iO.
appliances__c, Dishwasher;Disposal;Free Standing Refrigerator;Free Standing Electric Range
architectural_style__c, Modern/High Tech
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tile;Low-Flow Toilet(s);Quartz;Window
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1961
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-09-01
ffd_createddate, 2021-07-01T11:01:27.000+0000
days_on_market__c, 1280
dom__c, 92
ffd_description_pb, Incredible value for this stunning contemporary turn-key, 2 level townhome w/separate entrance. Complete renovation in 2018 of this spacious and bright unit, featuring a large skylight that floods the unit with natural light. An open floor plan greatroom with a sleek Blaze electric frplc framed w/stacked travertine stone, gray toned luxury vinyl plank flooring and a built-in dry bar create an ideal space for entertaining. Kitchen w/gray toned custom cabinetry, white quartz counter tops and stainless steel appliances. Full bath with a designer tiled walk-in shower and flooring plus new vanity and fixtures complete the lower level. A retro-hip loft style staircase leads to the 2nd level featuring 3 generous sized bedrooms with newer carpeting, addl closet space and full bath with a white porcelain tiled shower over tub and custom vanity. New electrical panel, new furnace & new double paned windows w/screens. Set back from the street, a stunning quiet unit w/pkg in rear. Must see unit.
district__c, SF District 6
driveway_sidewalks__c, Sidewalk/Curb/Gutter
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fireplace_features__c, Electric;Stone
pba__floortype_pb__c, Carpet;Tile;Vinyl
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2022-01-25T15:56:16.000+0000
pba__latitude_pb__c, 37.772197
pba__latitude_property__c, 37.772197
laundry_features__c, In Garage
listed_date__c, 2021-05-10
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Debra
pba__listing_agent_lastname__c, Despues
listing_agent_mls_id__c, 347354
ffd_listingagentname, Debra Despues
listing_agent_number__c, 347354
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 995000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.333Haight.com
pba__longitude_pb__c, -122.427676
mls_id__c, 421569195
main_level__c, Kitchen;Living Room;Dining Room
master_property__c, a0O8W00000DaE5lUAF
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-06-30
original_price__c, 1150000
overall_days_on_market__c, 153
parking_access__c, Side by Side
parking_features__c, Covered,Enclosed,Garage Door Opener,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2021-09-30
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 737.04
pba__propertytype__c, Tenancy In Common
id, a0E1I00000UUfqOUAT
roof__c, Other
room_type__c, Storage;Kitchen;Great Room
sale_date__c, 2021-11-12
sale_price__c, 995000
selling_agent_mls_id__c, 347356
selling_agent_number__c, 347356
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 1350
size__c, 1350
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Haight
subdist__c, Hayes Valley
ffd_name, 333 Haight Street #2, San Francisco, CA, 94102
website_property_type__c, Tenancy In Common
window_features__c, Dual Pane Full;Window Coverings;Window Screens
pba__yearbuilt_pb__c, 1961
pba__postalcode_pb__c, 94102
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530274084-1.jpg
ListingId, a0E1I00000UUfqOUAT
_yoast_indexnow_last_ping, 1735670051