meta_query='key:subdist__c;value:Midtown Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='323856' 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, 57 Greenview Court, San Francisco, CA, 94131
ffd_mls_id, 423717223
ffd_salesforce_id, a0E8W00000a837fUAA
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 57 Greenview Court, San Francisco, CA, 94131
pba__address_pb__c, 57 Greenview Court, San Francisco, CA, 94131
agent_only_remarks__c, Scheduled Showtimes: Twilight Tour Thu 1/26, 5-7 pm, Open House Sat 1/28 and Sun 1/29, 1-4 pm, Broker's Tour Tue 1/31, 1-3 pm, Twilight Tour Wed 2/1, 5-7 pm. Private showings also available - short advance notice is okay - text Vivian (415) 717-6308 for appointment. Visit 57Greenview.com for more information, floor and site plans, and video tour. Sq. ft. measurement includes lower level. It is approximate and per floor plan specialist(s). Permit status and legality of rooms down is unknown. Buyer to investigate and verify room count and sq. ft. to their satisfaction. Pest and home inspections done. Disclosure package available: https://app.disclosures.io/link/57-Greenview-Court-eddg7aoh and is also linked to MLS. Offer date set for Thursday Feb 2nd at 3:00 pm. Please submit offer on the latest SFAR purchase contract only, together with pre-approval letter, proof of funds and disclosure package cover sheet. Email offer to vivian@cityrealestatesf.com. 3% earnest money deposit wired to escrow and full disclosures to be submitted within 24 hours of acceptance. Escrow opened with DOMA - Katerina Rosignuolo #56606-22-06478.
appliances__c, Dishwasher;Disposal;Hood Over Range;Free Standing Gas Oven;Free Standing Refrigerator;Ice Maker;Self/Cont Clean Oven
architectural_style__c, Traditional;Mid-Century
bath_features__c, Tub w/Shower Over;Marble;Tile;Granite
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1957
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-01-25T23:46:11.000+0000
days_on_market__c, 6
dom__c, 5
ffd_description_pb, Mid-century traditional, fully detached home tucked away at the end of a tranquil cul-de-sac! This pristine, move-in ready home features three spacious bedrooms and two remodeled baths. Living room w/ wood-burning brick fireplace. Gourmet kitchen renovated with contemporary updates: granite countertops, high-end appliances and recessed lighting. Two rear, garden facing bedrooms upstairs, with roomy third bedroom downstairs. Additional flex space downstairs, ideal for office, media or family room. Refinished hardwood floors upstairs, brand-new carpet downstairs, new interior paint throughout, designer modern light fixtures, all dual pane windows and fresh landscaping outside. Massive corner, expansive lot - stretching approx. 7,800 sq. ft. in size. In the Midtown Terrace neighborhood, all of the utilities are underground, so no visible telephone or power lines. Close proximity to Forest Hill and West Portal Metro stations, West Portal Village restaurants and shops, and Portola Drive conveniences. Freeway access, public transportation, great schools, hiking trails, parks and a variety of green and open spaces all within minutes away. Suburban living in the heart of the city!
district__c, SF District 4
electric__c, 220 Volts
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood;Fenced;Partial;Metal
fireplace_features__c, Living Room;Wood Burning;Brick
pba__floortype_pb__c, Carpet;Tile;Wood
pba__hoafees__c, 18
pba__hoafrequency_pb__c, Annually
hoa_name__c, Midtown Terrace Home Owners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Fireplace(s)
ffd_lastmodifieddate, 2023-01-30T13:45:56.000+0000
pba__latitude_pb__c, 37.753438
pba__latitude_property__c, 37.753438
laundry_features__c, In Garage;Washer Included;Dryer Included;Sink
listed_date__c, 2022-12-16
pba__listing_agent_email__c, vivian@cityrealestatesf.com
pba__listing_agent_firstname__c, Vivian
pba__listing_agent_lastname__c, Lee
listing_agent_mls_id__c, 802845
ffd_listingagentname, Vivian Lee
listing_agent_number__c, 802845
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CITYRE
listing_office_name__c, City Real Estate
listing_office_number__c, 27425
pba__listingprice_pb__c, 1299000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.57greenview.com
pba__longitude_pb__c, -122.4513382
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage
mls_id__c, 423717223
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Tile;Marble;Granite;Window
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-01-25
open_house_end__c, 2023-01-31T15:00:00.000+0000
open_house_start__c, 2023-01-31T13:00:00.000+0000
original_price__c, 1299000
overall_days_on_market__c, -81473
parking_access__c, Independent
parking_features__c, Attached,Covered,Garage Door Opener,Garage Facing Front,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 792.07
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000a837fUAA
roof__c, Bitumen
room_type__c, Office;Kitchen;Living Room;Dining Room;Family Room;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Carbon Mon Detector;Window Security Bars
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 1640
size__c, 1640
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Greenview
subdist__c, Midtown Terrace
ffd_name, 57 Greenview Court, San Francisco, CA, 94131
view__c, Garden/Greenbelt;Twin Peaks;Sutro Tower
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Window Screens
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/530572485-1.jpg