meta_query='key:subdist__c;value:Midtown Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215429' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12175
[post_author] => 4
[post_date] => 2018-10-30 00:43:30
[post_date_gmt] => 2018-10-30 00:43:30
[post_content] => Mention Midtown Terrace to many San Franciscans and you’ll be met with a quizzical gaze. Where is it? What is it? It’s a mid-century neighborhood on the west side of Twin Peaks. Think single-family homes, fully detached, with both front and rear yards, lots of green space, and peace and quiet.
[post_title] => Midtown Terrace
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => midtown-terrace-2
[to_ping] =>
[pinged] =>
[post_modified] => 2022-12-14 03:45:03
[post_modified_gmt] => 2022-12-14 11:45:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12175
[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, 25 Sunview Drive, San Francisco, CA, 94131
ffd_mls_id, 506867
ffd_salesforce_id, a0E1I00000TRpoLUAT
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 25 Sunview Drive, San Francisco, CA, 94131
pba__address_pb__c, 25 Sunview Drive, San Francisco, CA, 94131
agent_only_remarks__c, Very easy to show, vacant and staged, please call, text Dena @ 415 407 4381 or email [email protected] for showings. Pest and contractor's inspections available. Pre sale Escrow opened with Mary Ann Bunnell @ Lawayer's Title Compnay FLNP-026200089 415 359 2501 [email protected]
appliances__c, Dishwasher;Electric Range;Disposal;Refrigerator;Freestanding Range;ENERGY STAR Qualified Appliances
architectural_style__c, Contemporary
bath_features__c, Shower Stall(s);Tub
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1957
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Betty A Taisch
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-10-09T16:45:51.000+0000
days_on_market__c, 848
dom__c, 24
ffd_description_pb, Where can you find a beautiful fully remodeled, sun drenched, single family home, detached on all sides and set in a garden with an over 9000 sqft lot minutes from downtown, Molly Stone and beautiful Twin Peaks and Glen Canyon Trails. The home boasts two good sized bedrooms and one bath on the upper level w a remodeled kitchen w quartz counters & a beautiful deck over looking the verdant garden. Living room and dining room enjoy a wood burning fireplace & great outlooks, on the lower level one finds an additional bedroom, bath and living room opening to the garden. This space can be used in multiple ways. 25 Sunview is the home that has it all.
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway
electric__c, 220 Volts in Kitchen
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Wood Burning
pba__floortype_pb__c, Tile;Wood;Simulated Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2023-02-04T11:48:17.000+0000
pba__latitude_pb__c, 37.74736183
pba__latitude_property__c, 37.74736183
laundry_features__c, Washer/Dryer Included
listed_date__c, 2020-10-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Dena
pba__listing_agent_lastname__c, Aslanian-Williams
listing_agent_mls_id__c, 803162
ffd_listingagentname, Dena Aslanian-Williams
listing_agent_number__c, 803162
listing_co_agent_mls_id__c, 347395
listing_co_agent_number__c, 347395
listing_co_office_mls_id__c, COMP12PUI
listing_co_office_name__c, Compass
listing_co_office_number__c, 27690
listing_office_mls_id__c, COMP12PUI
listing_office_name__c, Compass
listing_office_number__c, 27690
pba__listingprice_pb__c, 1549000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/467519334
pba__longitude_pb__c, -122.44704867
pba__lotsize_pb__c, 0.21
lower_level__c, Bedroom(s),Full Bath(s),Kitchen,Living Room
mls_id__c, 506867
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-10-09
original_price__c, 1549000
overall_days_on_market__c, -80635
parking__c, Attached,Garage,Interior Access
parking_access__c, Tandem
parking_features__c, Attached,Interior Access,Tandem Garage,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-11-02
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 987.06
pba__propertytype__c, Single Family Residence
id, a0E1I00000TRpoLUAT
roof__c, Composition
sale_date__c, 2020-12-04
sale_price__c, 1525000
selling_agent_mls_id__c, 813428
selling_agent_name__c, Danni S. Zhao
selling_agent_number__c, 1061215
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, 1545
size__c, 1545
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Sunview
subdist__c, Midtown Terrace
ffd_name, 25 Sunview Drive, San Francisco, CA, 94131
transportation__c, 1 Block
view__c, Garden/Greenbelt
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1957
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/371918-1.jpg
ListingId, a0E1I00000TRpoLUAT
