meta_query='key:subdist__c;value:Midtown Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='227974' 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
[to_ping] =>
[pinged] =>
[post_modified] => 2023-06-16 12:34:21
[post_modified_gmt] => 2023-06-16 19:34:21
[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, 95 Midcrest Way, San Francisco, CA, 94131
ffd_mls_id, 475231
ffd_salesforce_id, a0E1I0000044qdAUAQ
address2__c, 95 Midcrest Way, San Francisco, CA, 94131
pba__address_pb__c, 95 Midcrest Way, San Francisco, CA, 94131
agent_only_remarks__c, This is the home your clients have been waiting for. Ready to move-in. Pest report and contractor report in disclosures. Tax records show 1161 Square foot, graphic artist has measured 1385 for living space. Floor plan in disclosures. Remodeled kitchen and baths, new scheme coated walls, new paint, refinished hardwood floors. Please call or text Dena @ 415 407-4381 or D[email protected] to show. Offers Thurs Sept 13th by 1:00 p.m.
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1961
pba__city_pb__c, San Francisco
ffd_createddate, 2018-08-31T00:45:48.000+0000
days_on_market__c, 1784
dom__c, 32
ffd_description_pb, The home you have been waiting for, fully detached and tastefully remodeled 3 bedroom 2 bath home with gourmet kitchen, Ceasarstone counters, stainless steel appliances, open floor plan living room, dining room and kitchen. Wood burning fireplace in living room and hardwood floors throughout. Beautiful en-suite master at the lower level w tiled floors and remodeled bath and home office & low maintenance yard side. A beautiful protected deck is accessible from the main living floor. A one car garage completes this perfect home ready for the new owner. Close to all modes of transportation, freeways, shopping, Mollie Stone's Tower Market and restaurants of Glen Park ,Inner Sunset & West Portal, 95 Midcrest is the perfect home.
district__c, SF District 4
external_listing__c, 1
hoa_dues__c, 0
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
ffd_lastmodifieddate, 2022-03-01T19:55:24.000+0000
pba__latitude_pb__c, 37.748203
pba__latitude_property__c, 37.748203
listed_date__c, 2018-07-19
pba__listing_agent_firstname__c, Dena
pba__listing_agent_lastname__c, Aslanian-Williams
listing_agent_mls_id__c, 803162
listing_agent_number__c, 803162
listing_co_agent_mls_id__c, 347395
listing_co_agent_number__c, 347395
listing_co_office_mls_id__c, PACU
listing_co_office_name__c, Pacific Union International Inc.
listing_co_office_number__c, 25770
listing_office_mls_id__c, PACU
listing_office_name__c, Pacific Union International Inc.
listing_office_number__c, 25770
pba__listingprice_pb__c, 1395000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=3iGyg9ECmYa
pba__longitude_pb__c, -122.449387
pba__lotsize_pb__c, 0.06
mls_id__c, 475231
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2018-08-30
original_price__c, 1395000
overall_days_on_market__c, 1784
parking__c, Attached,Auto Door,Interior Access
parking_access__c, Side-by-Side
parking_type__c, On Site
price_per_square_foot__c, 1140.79
pba__propertytype__c, Single-Family Home
id, a0E1I0000044qdAUAQ
sale_date__c, 2018-10-18
sale_price__c, 1580000
selling_agent_mls_id__c, 342699
selling_agent_name__c, Joske M. Thompson
selling_agent_number__c, 342699
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Pacific Union International Inc.
pba__status__c, Sold
pba__totalarea_pb__c, 1385
size__c, 1385
pba__state_pb__c, CA
pba__street_pb__c, Midcrest
subdist__c, Midtown Terrace
ffd_name, 95 Midcrest Way, San Francisco, CA, 94131
transportation__c, 2 Blocks
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1961
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/341458-1.jpg
ListingId, a0E1I0000044qdAUAQ
