meta_query='key:subdist__c;value:Midtown Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='327430' 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, 50 Farview Court, San Francisco, CA, 94131
ffd_mls_id, 423726521
ffd_salesforce_id, a0E8W00000bFgozUAC
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 50 Farview Court, San Francisco, CA, 94131
pba__address_pb__c, 50 Farview Court, San Francisco, CA, 94131
agent_only_remarks__c, Bedroom down was called a family room by previous listing agent.
appliances__c, Dishwasher;Built-In Refrigerator
bath_features__c, Tub;Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1958
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-03-13T10:48:35.000+0000
days_on_market__c, 17
dom__c, 17
ffd_description_pb, Welcome home! Located on a quiet cul-de-sac in desirable Midtown Terrace, western slope of the famous Twin Peaks, 50 Farview has it all: spectacular panoramic views of Twin Peaks and ocean, comfortable floor plan, ample street parking with no street cleaning restrictions, a charming backyard surrounded by greenery, and a central San Francisco location. On the main level, you will find the full kitchen renovation which includes new Viking appliances and new quartz counters. The adjoining living and dining space spill onto the sun-kissed deck and rear backyard. An updated full bathroom which features a 8 ft entire ceiling skylight and two bedrooms complete the main level. Downstairs you will find access to the two-car garage, workroom, and a spacious permitted family room and full bathroom. A short distance to Twin Peaks, where you can experience the top of the world feeling with all around spectacular views of San Francisco, numerous pet friendly trails and so much more! Close to world renowned UCSF Parnassus hospital, Castro, Haight-Ashbury and Golden Gate Park, 101 & 280 freeways, highly rated Clarendon Alternative Elementary School, and only minutes away from public transportation (bus stop half a block away:Muni line 36 to Forest Hill & Glen Park Bart Stations.
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
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-03-30T10:48:24.000+0000
pba__latitude_pb__c, 37.7549581
pba__latitude_property__c, 37.7549581
laundry_features__c, In Garage
listed_date__c, 2023-03-10
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Dan
pba__listing_agent_lastname__c, McLean
listing_agent_mls_id__c, 802350
ffd_listingagentname, Dan McLean
listing_agent_number__c, 802350
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 1795000
pba__listingtype__c, Sale
pba__listing_website__c, https://youtu.be/HjIMinHFNM0
pba__longitude_pb__c, -122.4506535
lower_level__c, Bedroom(s),Full Bath(s),Garage,Street Entrance
mls_id__c, 423726521
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-03-13
open_house_end__c, 2023-04-02T16:00:00.000+0000
open_house_start__c, 2023-04-02T13:00:00.000+0000
original_price__c, 1795000
overall_days_on_market__c, -81520
parking_access__c, Tandem
parking_features__c, 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, 1205.51
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bFgozUAC
sale_date__c, 1800-01-01
sale_price__c, 0
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, 1489
size__c, 1489
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Farview
subdist__c, Midtown Terrace
ffd_name, 50 Farview Court, San Francisco, CA, 94131
view__c, City;Twin Peaks;Mountains
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1958
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530589257-1.jpg
