meta_query='key:subdist__c;value:Corona Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217599' 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] => 2024-03-19 13:40:29
[post_modified_gmt] => 2024-03-19 20:40:29
[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, 488 Roosevelt Way, San Francisco, CA, 94114
ffd_mls_id, 421526385
ffd_salesforce_id, a0E1I00000Tx5J8UAJ
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 2
address2__c, 488 Roosevelt Way, San Francisco, CA, 94114
pba__address_pb__c, 488 Roosevelt Way, San Francisco, CA, 94114
agent_only_remarks__c, Subject to all Covid safety protocols. Please email signed PEAD V prior to any showings. PLEASE NOTE: The seller has NOT verified that the property has been properly disinfected and is NOT providing personal protective equipment at the property to protect against exposure to COVID-19. Any party who enters the home must provide their own appropriate protective items and must enter at their own risk. Offer date April 1 at 2pm, no pre-emptive offers please. Trust sale with independent admin, so we must go full marketing period. SFAR contract only please and please give 48 hours for response as the Administrator is out of town and must consult with the family. No court confirmation required. Thanks. Note: tax records show 2200 sq feet which is totally wrong. Most recent Matterport shows 1530 and an earlier Home Depot measurement before renovations showed 1370, but some space was opened up during renovations... Neither sellers nor agents warrant square footage.
appliances__c, Dishwasher;Insulated Water Heater;Microwave;Hood Over Range;ENERGY STAR Qualified Appliances;Free Standing Refrigerator;Self/Cont Clean Oven;Free Standing Electric Oven;Free Standing Electric Range
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Tile;Low-Flow Toilet(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1980
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Corey Ye
pba__contingentdate__c, 2021-04-03
ffd_createddate, 2021-03-23T12:44:20.000+0000
days_on_market__c, 849
dom__c, 24
ffd_description_pb, Freshly updated and remodeled two level, 3 bedroom, 2 bath condo in a small two unit building. New kitchen and baths, flooring, lighting and more. Lovely views over Eureka Valley. Dedicated, south facing, front deck off lower level and a small step out patio off the primary bedroom on the upper level. The primary also features a walk-in closet and ensuite bath. Large one car garage with extra storage. Vacant and ready for you to move right in. Great location with quick access to half a dozen neighborhood villages including Castro/Upper Market, Duboce Triangle, Cole Valley, Divisadero, Lower Haight and more. Transportation right outside and fairly quick access to freeways. Also near several wonderful parks including Buena Vista and Corona Hts Park.
district__c, SF District 5
driveway_sidewalks__c, Sidewalk/Curb/Gutter
electric__c, 220 Volts in Laundry
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Tile;Simulated Wood
hoa_fee_includes__c, Insurance
pba__hoafees__c, 100
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 488 Roosevelt Way
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Gas
height_limit__c, Unknown
ffd_lastmodifieddate, 2022-01-25T15:46:46.000+0000
pba__latitude_pb__c, 37.763547
pba__latitude_property__c, 37.763547
laundry_features__c, Laundry Closet;Hookups Only
listed_date__c, 2021-03-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, Woodruff
listing_agent_mls_id__c, 239976
ffd_listingagentname, John L Woodruff III
listing_agent_number__c, 239976
listing_co_agent_mls_id__c, 811586
listing_co_agent_number__c, 1052445
listing_co_office_mls_id__c, AETHOS
listing_co_office_name__c, Aethos Real Estate
listing_co_office_number__c, 27302
listing_office_mls_id__c, AETHOS
listing_office_name__c, Aethos Real Estate
listing_office_number__c, 27302
pba__listingprice_pb__c, 1299000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=HkJEpzpiCKc
pba__longitude_pb__c, -122.443695
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 421526385
main_level__c, Full Bath(s);Master Bedroom;Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Low-Flow Toilet(s);Quartz;Tile
master_property__c, a0O1I00000CFQX8UAP
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-03-22
original_price__c, 1299000
overall_days_on_market__c, 100
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener,Garage Facing Front
parking_type__c, On Site - Mapped (Condo Only)
patio_and_porch_features__c, Uncovered Deck;Uncovered Patio
pba__pendingdate__c, 2021-04-15
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1065.36
pba__propertytype__c, Condominium
id, a0E1I00000Tx5J8UAJ
road_surface_type__c, Asphalt,Paved
roof__c, Composition
room_type__c, Kitchen;Living Room;Master Bathroom;Dining Room;Master Bedroom
sale_date__c, 2021-05-03
sale_price__c, 1630000
selling_agent_mls_id__c, 398474
selling_agent_number__c, 398474
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Coldwell Banker Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1530
size__c, 1530
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Roosevelt
subdist__c, Corona Heights
ffd_name, 488 Roosevelt Way, San Francisco, CA, 94114
view__c, City Lights;Hills
website_property_type__c, Condominium
window_features__c, Dual Pane Full;Caulked/Sealed
pba__yearbuilt_pb__c, 1980
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530195680-1.jpg
ListingId, a0E1I00000Tx5J8UAJ