meta_query='key:subdist__c;value:Midtown Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='334156' 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] => 2024-03-19 12:25:06
[post_modified_gmt] => 2024-03-19 19:25:06
[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, 75 Skyview Way, San Francisco, CA, 94131
ffd_mls_id, 423744513
ffd_salesforce_id, a0E8W00000awflBUAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 75 Skyview Way, San Francisco, CA, 94131
pba__address_pb__c, 75 Skyview Way, San Francisco, CA, 94131
agent_only_remarks__c, Disclosures: https://app.glide.com/shared/request/ff801806-f519-4c31-8ca1-5a1eda9fe7fd
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1956
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-05-26T01:48:56.000+0000
days_on_market__c, 55
dom__c, 8
ffd_description_pb, Experience contemporary elegance and indoor-outdoor living in this magnificent Midtown Terrace home. With breathtaking westward views, this beautifully renovated residence offers a haven of serenity amidst the bustling city. Step inside and be captivated by the seamless blend of modern sophistication and timeless charm. The upper level features two beautifully appointed bedrooms with ample natural light, Elfa closet systems, and a tastefully designed bathroom with a modern stall shower and separate soaking tub. Practical improvements in the home also include an updated electrical system, all new lighting with Lutron switches throughout for home automation, a newer roof and flooring, and double-paned windows. The lower level provides versatility with a bonus office space and a large garage, offering endless possibilities. Continue to expand given the tall ceilings or use it as a productive workspace, a creative studio, or even as a spacious gym, as the current owners have done. Embrace the beauty of nature with the multi-level yard that seamlessly integrates indoor and outdoor living. Relax and entertain in this private oasis, perfect for hosting intimate gatherings or enjoying a quiet evening under the stars. Create lifelong memories in this enchanting yard.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-07-13T18:55:43.000+0000
pba__latitude_pb__c, 37.7510093
pba__latitude_property__c, 37.7510093
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2023-04-04
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Alex
pba__listing_agent_lastname__c, Shvartsman
listing_agent_mls_id__c, 901780
ffd_listingagentname, Alex M Shvartsman
listing_agent_number__c, 901780
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 28739
pba__listingprice_pb__c, 1599000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=96wX1TXAMNH&brand=0&mls=1&
pba__longitude_pb__c, -122.4502088
mls_id__c, 423744513
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-05-25
original_price__c, 1599000
overall_days_on_market__c, -81593
parking_access__c, Independent
parking_features__c, Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-06-02
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000awflBUAQ
room_type__c, Bonus Room
sale_date__c, 2023-06-26
sale_price__c, 1700000
selling_agent_mls_id__c, 800061
selling_agent_number__c, 800061
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Icon Properties
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Skyview
subdist__c, Midtown Terrace
ffd_name, 75 Skyview Way, San Francisco, CA, 94131
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1956
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530623604-1.jpg