meta_query='key:subdist__c;value:Midtown Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='327002' 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, 57 Longview Court, San Francisco, CA, 94131
ffd_mls_id, 423716524
ffd_salesforce_id, a0E8W00000bDwloUAC
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 57 Longview Court, San Francisco, CA, 94131
pba__address_pb__c, 57 Longview Court, San Francisco, CA, 94131
agent_only_remarks__c, Contact listing agent for a showing appointment & disclosure package. Property being sold As Is, tenant occupied and subject to tenant's rights. Current rent is $4,000 per month, $5,000 per month starting March 1, 2023. The downstairs addition of the 4th bedroom/family room and half bath are not reflected in the tax records. Buyer to cooperate with Seller on a 1031 tax exchange at no cost or liability to Buyer. Escrow opened with Mia McDowell /Old Republic Title. Seller reserves the right to accept or decline any offer.
appliances__c, Dishwasher;Gas Water Heater;Disposal;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Mid-Century
bath_features__c, Shower Stall(s);Tub;Tile;Window
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1955
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-02-14T11:51:00.000+0000
days_on_market__c, 156
dom__c, 0
ffd_description_pb, Welcome to 57 Longview Court where this timeless, Mid-Century Modern, fully detached home awaits its next owner. Ideally situated on a tranquil cul-de-sac, this home sits on an extra large flat lot with a large basement waiting for additional expansion. The main living space has three bedrooms all on the same floor where the ocean views from the living room and dining room windows can be enjoyed while sitting around the cozy brick fireplace. The back two bedrooms have equally dreamy ocean views. The interior staircase leads to a 4th large bedroom or family room with several built-ins, multiple closets and a half-bath. Garage and backyard access is available from this living space & there is an abundant amount of space for expansion. This classic home has been in the same family since it was built in 1955. It has been thoughtfully maintained and welcomes some cosmetic upgrades. The serine neighborhood is home to some of San Francisco's public best schools, parks, hiking trails and of course, views!
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Brick;Gas Piped
pba__floortype_pb__c, Carpet;Laminate;Wood
pba__hoafees__c, 18
pba__hoafrequency_pb__c, Annually
hoa_name__c, Midtown Terrace HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-07-13T18:17:11.000+0000
pba__latitude_pb__c, 37.7480926
pba__latitude_property__c, 37.7480926
laundry_features__c, In Garage;Washer Included;Dryer Included;Sink
listed_date__c, 2022-11-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Pamela
pba__listing_agent_lastname__c, Parker Murphy
listing_agent_mls_id__c, 812647
ffd_listingagentname, Pam Parker Murphy
listing_agent_number__c, 1057609
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CIP01
listing_office_name__c, Corcoran Icon Properties
listing_office_number__c, 28939
pba__listingprice_pb__c, 1385000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4509003
lower_level__c, Family Room,Garage,Partial Bath(s)
mls_id__c, 423716524
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance;Primary Bedroom
monthly_parking_fees__c, 0
monthlyrent__c, 4000
parkingspaces__c, 2
on_market_date__c, 2023-02-13
original_price__c, 1385000
overall_days_on_market__c, -81492
parking_access__c, Tandem
parking_features__c, 24'+ Deep Garage,Attached,Enclosed,Garage Door Opener,Garage Facing Front,Interior Access,Tandem Garage,Workshop in Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2023-02-13
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 807.47
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bDwloUAC
room_type__c, Kitchen;Living Room;Dining Room;Family Room
sale_date__c, 2023-03-02
sale_price__c, 1275000
selling_agent_mls_id__c, 806887
selling_agent_number__c, 166017801
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sequoia Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1579
size__c, 1579
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Longview
subdist__c, Midtown Terrace
ffd_name, 57 Longview Court, San Francisco, CA, 94131
view__c, Ocean;Water;San Francisco
website_property_type__c, Single Family Home
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/530570622-1.jpg
