meta_query='key:subdist__c;value:Midtown Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214513' 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, 54 Longview Court, San Francisco, CA, 94131
ffd_mls_id, 505070
ffd_salesforce_id, a0E1I00000THdkyUAD
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 54 Longview Court, San Francisco, CA, 94131
pba__address_pb__c, 54 Longview Court, San Francisco, CA, 94131
agent_only_remarks__c, per previous owner lower level was done without permits. Please review showing protocol here: https://drive.google.com/file/d/1Aegx9x74cmc0yCyvc58yMqCilgPpTkaZ/view. Owner occupied. Escrow pre-opened with Nate Scharton, ORTC. All entrants must sign a PEAD before entry, acknowledge the Compass Covid Showing Protocol, and bring their own masks, gloves and booties.
appliances__c, Dishwasher;Gas Water Heater;Disposal;Refrigerator;Cooktop Stove;Double Oven;Ice Maker
bath_features__c, Shower Stall(s);Tub;Remodeled
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1955
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-09-06
ffd_createddate, 2020-09-05T00:48:08.000+0000
days_on_market__c, 1048
dom__c, 5
ffd_description_pb, With over 1700 sq. ft. of living space this exquisitely redesigned, fully detached, mid-century modern residence will never let you leave home! If you are looking for a property that offers all the comforts of a SIP haven including expansive indoor and outdoor living, look no further. Main floor features a remodeled gourmet chef's kitchen, expansive living / dining room with fireplace, 2 bedrooms that open a huge walkout deck with sweeping views, and a large remodeled bathroom with separate tub and shower. Ground floor offers the homes 3d bedroom, full bathroom, family room, office, gym, laundry area, a one-car garage with storage, and direct access to the landscaped yard, patio, sitting area and hot tub. The list of improvements made by the previous owners is quite impressive, shows true pride of ownership, and makes this property a must see to appreciate! Midtown Terrace is centrally located to all San Francisco has to offer, including walking distance to Miraloma Shopping Plaza.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_dues__c, 18
pba__hoafees__c, 18
pba__hoafrequency_pb__c, Annually
hoa_name__c, Midtown Terrace HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:33:23.000+0000
pba__latitude_pb__c, 37.7483832
pba__latitude_property__c, 37.7483832
laundry_features__c, Inside Room;Hookups Only
listed_date__c, 2020-08-05
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Gary
pba__listing_agent_lastname__c, Snow
listing_agent_mls_id__c, 804956
ffd_listingagentname, Gary J Snow
listing_agent_number__c, 166014699
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7PAR
listing_office_name__c, Compass SF
listing_office_number__c, 27677
pba__listingprice_pb__c, 1495000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=CsATVbhBnVP&mls=1
pba__longitude_pb__c, -122.4509174
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s),Family Room
mls_id__c, 505070
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-09-04
original_price__c, 1495000
overall_days_on_market__c, 87
parking__c, Attached,Garage,Interior Access
parking_access__c, Independent
parking_features__c, Attached,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-09-09
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1011.56
pba__propertytype__c, Single Family Residence
id, a0E1I00000THdkyUAD
room_type__c, Office;Laundry;Game Room
sale_date__c, 2020-10-07
sale_price__c, 1750000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 115218
selling_agent_name__c, Debbie J. Herzfeld
selling_agent_number__c, 115218
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass SF
pba__status__c, Closed
pba__totalarea_pb__c, 1730
size__c, 1730
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Longview
subdist__c, Midtown Terrace
ffd_name, 54 Longview Court, San Francisco, CA, 94131
transportation__c, 2 Blocks
view__c, Ocean;Twin Peaks
website_property_type__c, Single Family Home
window_features__c, Dual Pane;Window Screens
pba__yearbuilt_pb__c, 1955
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/369665-1.jpg
ListingId, a0E1I00000THdkyUAD