meta_query='key:subdist__c;value:Corona Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='329706' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15601
[post_author] => 4
[post_date] => 2018-11-02 02:29:46
[post_date_gmt] => 2018-11-02 02:29:46
[post_content] => Above it all but still in the thick of it, with a great neighborhood dog run, park, and community museum/center. Winding curves, steep hills, jaw-dropping views, sudden changes in direction. You aren't lost. You're in Corona Heights.
[post_title] => Corona Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => corona-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2018-11-02 02:29:46
[post_modified_gmt] => 2018-11-02 02:29:46
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15601
[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, 3042 Market Street, San Francisco, CA, 94114
ffd_mls_id, 423732939
ffd_salesforce_id, a0E8W00000bbDxRUAU
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 2
address2__c, 3042 Market Street, San Francisco, CA, 94114
pba__address_pb__c, 3042 Market Street, San Francisco, CA, 94114
agent_only_remarks__c, Please call Mike to show and for disclosures 415-308-4281. No lockbox. 51% ownership in newly forming TIC 3042/3044 Market Street. Open Sat/Sun 1-4pm, Tuesday 12-2pm, Tuesday twilight 5-6:30pm. Updated full floor flat opening to an exclusive use patio and garden. 3 bedrooms/1 bath, large bright kitchen and living/dining great room. 1 car tandem parking for a small car. Ideal location close to Castro and Upper Market shopping, dining, and transit. Note: $300 per month dues is an estimate. Final determination will be made with new buyer and co owner in 3044. New SIRKIN TIC agreement in place
appliances__c, Dishwasher;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Bernard Katzmann
pba__contingentdate__c, 2023-04-24
ffd_createddate, 2023-04-13T21:48:53.000+0000
days_on_market__c, 43
dom__c, 32
ffd_description_pb, Wonderful Corona Heights full floor flat opening to an exclusive use patio and landscaped rear garden. Behind this handsome Victorian facade lies a spacious updated home with tall ceilings, recessed lighting and vinyl wood floors. The large living/dining room great room enjoys high ceilings, moldings, recessed and custom lighting and garden outlooks. The spacious kitchen is flooded with morning light and features tile floors, stainless counters, custom tile backsplash and industrial style pendant lighting. Stainless appliances include a 6-burner commercial-style gas range, three-door refrigerator, and dishwasher. French doors open to the magical rear patio and garden. There are 2 spacious bedrooms with custom lighting and a 3rd smaller bedroom perfect for guests or a home office. The large bathroom has tile floors, custom pendant lighting, spacious double vanity, and over-sized soaking tub. The recently landscaped exclusive use rear patio and garden, with planters and mature foliage is perfect for entertaining, barbeques or peaceful relaxation. Tandem parking for a small car plus exclusive use storage in the garage. Washer/dryer for 3042 on rear porch. Ideal location with prime access to restaurants, shopping and amenities in the Upper Market and the Castro neighborhoods
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Full
pba__floortype_pb__c, Tile;Vinyl
pba__hoafees__c, 300
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 3042/3044 TIC Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Electric;Wall Furnace
ffd_lastmodifieddate, 2023-05-26T10:49:43.000+0000
pba__latitude_pb__c, 37.761289
pba__latitude_property__c, 37.761289
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2023-03-20
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Michael
pba__listing_agent_lastname__c, Shaw
listing_agent_mls_id__c, 800323
ffd_listingagentname, Michael H Shaw
listing_agent_number__c, 800323
listing_co_agent_mls_id__c, 263622
listing_co_agent_number__c, 263622
listing_co_office_mls_id__c, VANG03
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 1228
listing_office_mls_id__c, VANG03
listing_office_name__c, Vanguard Properties
listing_office_number__c, 1228
pba__listingprice_pb__c, 875000
pba__listingtype__c, Sale
pba__listing_website__c, https://youtu.be/NPOkoU75_g0
pba__longitude_pb__c, -122.442175
mls_id__c, 423732939
main_level__c, Bedroom(s);Kitchen;Living Room;Primary Bedroom
master_bathroom_features__c, Double Sinks;Tile;Soaking Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-04-13
original_price__c, 875000
overall_days_on_market__c, -81551
parking_access__c, Tandem
parking_features__c, Attached,Size Limited,Tandem Garage
parking_type__c, On Site - Unassigned (Condo Only)
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2023-05-15
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-05-25T17:41:35.000+0000
price_per_square_foot__c, 887.99
pba__propertytype__c, Tenancy In Common
ListingId, a0E8W00000bbDxRUAU
room_type__c, Kitchen;Living Room;Baths Other;Primary Bathroom
sale_date__c, 2023-05-23
sale_price__c, 880000
security_features__c, Security Gate
selling_agent_mls_id__c, 806539
selling_agent_number__c, 166017166
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, City Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 991
size__c, 991
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Market
subdist__c, Corona Heights
ffd_name, 3042 Market Street, San Francisco, CA, 94114
website_property_type__c, Tenancy In Common
window_features__c, Dual Pane Partial
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530603177-1.jpg