meta_query='key:subdist__c;value:Midtown Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237110' 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, 34 Greenview Court, San Francisco, CA, 94131
ffd_mls_id, 422666379
ffd_salesforce_id, a0E8W00000Xi5YXUAZ
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 34 Greenview Court, San Francisco, CA, 94131
pba__address_pb__c, 34 Greenview Court, San Francisco, CA, 94131
agent_only_remarks__c, 4th BDRM access thru primary BDRM. Total floor measurement by an appraiser: 1470 up/804 down/559 garage. Please use San Francisco purchase agreement. Seller reserves right to accept, counter, & reject any offer. Pre-sale escrow opened w/Helen Dumont at ORTC 2566 Ocean Avenue, SF.0216036659-HD. Original owners. Gas range/electric oven.
appliances__c, Dishwasher;Disposal;Hood Over Range;Free Standing Gas Range;Gas Cook Top
architectural_style__c, Mid-Century
bath_features__c, Shower Stall(s);Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1957
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-06-10T16:47:04.000+0000
days_on_market__c, 405
dom__c, 11
ffd_description_pb, Much loved and well cared for home located on a cul-de-sac in the Midtown Terrace neighborhood. Original oak floors in living, dining and three of the four bedrooms upstairs. Custom wood shutters in living and dining rooms along with the newly painted brick hearth at the fireplace, add a polished look to the property. Light, bright kitchen has a sitting area, new refrigerator, new range fan and has been freshly painted. Deck off of the primary bedroom looks over the lovely backyard with a variety of plants, including roses. Downstairs brings you into the laundry area with folding counter, storage, desk space, access to the workshop and to the backyard. Also downstairs is the large family room with tons of storage and bath, which adds so many options to this home. There are two access doors to the garage and multiple storage areas in the garage as well. This is a very special City block with friendly neighbors who treasure their little cul-de-sac location.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fencing__c, Partial
fireplace_features__c, Living Room;Brick
pba__floortype_pb__c, Carpet;Laminate;Linoleum;Tile;Vinyl;Wood;Simulated 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;Gas
ffd_lastmodifieddate, 2023-07-13T17:13:02.000+0000
pba__latitude_pb__c, 37.7530552
pba__latitude_property__c, 37.7530552
laundry_features__c, Ground Floor;Washer Included;Dryer Included
listed_date__c, 2022-05-17
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Lynn
pba__listing_agent_lastname__c, Flynn
listing_agent_mls_id__c, 981856
ffd_listingagentname, Lynn Flynn
listing_agent_number__c, 1032528
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, BARBCO
listing_office_name__c, BarbCo
listing_office_number__c, 28297
pba__listingprice_pb__c, 1599950
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4514282
lower_level__c, Family Room,Garage,Partial Bath(s)
mls_id__c, 422666379
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Tub w/Shower Over;Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-06-09
original_price__c, 1599950
overall_days_on_market__c, -81243
parking_access__c, Side by Side
parking_features__c, Attached
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2022-06-20
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1156.81
pba__propertytype__c, Single Family Residence
record_id, a0E8W00000Xi5YXUAZ
room_type__c, Laundry;Family Room;Workshop
sale_date__c, 2022-07-20
sale_price__c, 1800000
selling_agent_mls_id__c, 811218
selling_agent_number__c, 1050472
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1556
size__c, 1556
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Greenview
subdist__c, Midtown Terrace
ffd_name, 34 Greenview Court, San Francisco, CA, 94131
website_property_type__c, Single Family Home
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/530475757_135d80a4-2d06-4381-91db-784f9d5906bf.jpg
ListingId, a0E8W00000Xi5YXUAZ