meta_query='key:subdist__c;value:Corona Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='326888' 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, 64 Mars Street, San Francisco, CA, 94114
ffd_mls_id, 422706405
ffd_salesforce_id, a0E8W00000ZMS8sUAH
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 64 Mars Street, San Francisco, CA, 94114
pba__address_pb__c, 64 Mars Street, San Francisco, CA, 94114
agent_only_remarks__c, As-Is sale. Great opportunity. Easy to show. Contact Bill at 415-309-7279.
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1908
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-11-03T19:46:57.000+0000
days_on_market__c, 258
dom__c, 97
ffd_description_pb, Attention contractors and buyers with imagination! This diamond in the rough is an excellent opportunity to create a wonderful home in one of San Francisco's most coveted neighborhoods. On the main level, the large living room has a fireplace, coved ceilings and bay windows with unobstructed views of the City to the Bay. Classic pocket doors open from the living room to the large dining room with built-in cabinet. The kitchen and half-bath have been removed and are waiting for a new owner. Stairs descend to a recently remodeled bedroom and bath. This room has a private entrance from the front of the home. The upper level consists of two, nice sized bedrooms. The front bedroom has amazing views and the rear bedroom has direct access to a deck and stairs to a spacious yard. There is also a full bath on this level. There is also a one-car garage. 64 Mars Street is minutes from the Castro, Cole Valley and Haight Ashbury neighborhoods,public transportation and Buena Vista Park.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Wood Burning
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2023-07-13T18:05:13.000+0000
pba__latitude_pb__c, 37.761027
pba__latitude_property__c, 37.761027
listed_date__c, 2022-06-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, William
pba__listing_agent_lastname__c, Kitchen
listing_agent_mls_id__c, 803707
ffd_listingagentname, William J Kitchen Jr.
listing_agent_number__c, 803707
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1675000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4448
lower_level__c, Bedroom(s),Full Bath(s),Street Entrance
mls_id__c, 422706405
master_bathroom_features__c, Tub w/Shower Over
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-11-03
original_price__c, 1675000
overall_days_on_market__c, -81390
parking_access__c, Independent
parking_features__c, Garage Facing Front
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-02-08
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 686.5
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000ZMS8sUAH
road_surface_type__c, Paved
sale_date__c, 2023-03-01
sale_price__c, 1500000
selling_agent_mls_id__c, 812066
selling_agent_number__c, 1054714
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Real Brokerage Technologies
pba__status__c, Closed
pba__totalarea_pb__c, 2185
size__c, 2185
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Mars
subdist__c, Corona Heights
ffd_name, 64 Mars Street, San Francisco, CA, 94114
view__c, City;Bay;San Francisco;Hills
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1908
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530550581-1.jpg