217 Warren Drive, San Francisco, CA, 94131 - Property Description

ffd_listing_title,620 Clarendon Avenue, San Francisco, CA, 94131

ffd_mls_id,423913141

ffd_salesforce_id,a0E8W00000dTwwmUAC

num_of_fireplaces__c,0

num_of_rooms__c,6

of_units__c,0

address2__c,620 Clarendon Avenue, San Francisco, CA, 94131

pba__address_pb__c,620 Clarendon Avenue, San Francisco, CA, 94131

agent_only_remarks__c,Incredible price drop - under $700/sq. ft! Similar townhouse sold in 2022 for $1,479,000! For the right price, Seller is offering a credit towards 6 months of HOA dues (water, building insurance, prof management, common area gas and electric, exterior maintenance & landscaping, access to the gym, community center & sauna). This is a speical & unique gated community that offers privacy, safety and quiet and unlike anything else found in the surrounding areas, yet has such close access to West Portal and the Inner Sunset/Parnassus Heights. Presale escrow #3652300558 with Joanne Kung, Chicago Title.(415) 252-2770; [email protected]. Contact agents for gate code and location of lockbox. Disclosures here: https://app.disclosures.io/link/620-Clarendon-Avenue-gxatrp3e

appliances__c,Dishwasher;Microwave;Free Standing Refrigerator;Free Standing Electric Oven;Free Standing Electric Range

architectural_style__c,Contemporary

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1977

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Natalie Rome

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-09-29T17:47:19.000+0000

days_on_market__c,67

dom__c,67

ffd_description_pb,Set amidst the tranquil surroundings of The Woods, 620 Clarendon Avenue welcomes you to a comfortable and inviting 3-bedroom, 2.5-bathroom townhome spread across three levels. This gated community sits between the charming Forest Hill and Forest Knolls neighborhoods. Inside, the main level is designed for practical living. The open kitchen/dining area is perfect for cooking and dining with a view of the greenery. There's a handy half bath for guests and a spacious living room with a cozy fireplace and wet bar for relaxation. Upstairs, you'll find 3 bedrooms and 2 bathrooms. Flooring features a combination of new carpet & luxury vinyl plank floors. Large windows let in plenty of natural light, and the interior has been freshly painted. Parking is easy with a roomy 2-car garage that also provides extra storage space. As a resident, you'll have access to The Woods' community social center. It includes a gym, sauna, deck, and event space for your enjoyment. Beyond your home, you'll have hiking trails nearby, and you can explore the shops in West Portal and Irving Street. Forest Hill MUNI and nearby freeway access make transportation a breeze. 620 Clarendon Avenue offers a comfortable and convenient lifestyle, blending modern living with the tranquility of nature. Welcome home!

district__c,SF District 4

driveway_sidewalks__c,Gated

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Tile;Vinyl

pba__hoafees__c,1172

pba__hoafrequency_pb__c,Monthly

hoa_name__c,The Woods of San Francisco

hoa__c,Yes

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Gas

interior_features__c,Wet Bar

ffd_lastmodifieddate,2023-12-05T11:47:28.000+0000

pba__latitude_pb__c,37.752223

pba__latitude_property__c,37.752223

laundry_features__c,Washer Included;Dryer Included

listed_date__c,2023-09-29

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Derek

pba__listing_agent_lastname__c,Chin

listing_agent_mls_id__c,189082

ffd_listingagentname,Derek Chin

listing_agent_number__c,189082

listing_co_agent_mls_id__c,803584

listing_co_agent_number__c,803584

listing_co_office_mls_id__c,COMP

listing_co_office_name__c,Compass

listing_co_office_number__c,26293

listing_office_mls_id__c,COMP

listing_office_name__c,Compass

listing_office_number__c,26293

pba__listingprice_pb__c,1198000

pba__listingtype__c,Sale

pba__listing_website__c,https://www.620clarendon.com/mls

pba__longitude_pb__c,-122.457897

mls_id__c,423913141

main_level__c,Partial Bath(s);Kitchen;Living Room;Dining Room

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2023-09-29

open_house_end__c,2023-12-09T16:00:00.000+0000

open_house_start__c,2023-12-09T14:00:00.000+0000

original_price__c,1329000

overall_days_on_market__c,-81720

parking_access__c,Side by Side

parking_features__c,Garage Door Opener,Garage Facing Front,Guest Parking Available,Interior Access,Side-by-Side

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,679.52

pba__propertytype__c,Townhouse

ListingId,a0E8W00000dTwwmUAC

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,1763

size__c,1763

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Clarendon

subdist__c,Forest Knolls

ffd_name,620 Clarendon Avenue, San Francisco, CA, 94131

website_property_type__c,Townhouse

pba__yearbuilt_pb__c,1977

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530684957-1.jpg

_yoast_indexnow_last_ping,1701778356

ffd_listing_title,125 Galewood Circle, San Francisco, CA, 94131

ffd_mls_id,423759722

ffd_salesforce_id,a0E8W00000dSDiyUAG

num_of_fireplaces__c,1

num_of_rooms__c,7

of_units__c,0

address2__c,125 Galewood Circle, San Francisco, CA, 94131

pba__address_pb__c,125 Galewood Circle, San Francisco, CA, 94131

agent_only_remarks__c,Currently tenant occupied, with a family that has three kids and paying $5,000/month. Escrow opened with Nancy Chan of Chicago Title. Disclosures available upon request. Will be open on Brokers Tour, 9/19 from 1-3pm. Other showings are limited and need 72hr advanced notice.

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1979

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-09-08T10:47:36.000+0000

days_on_market__c,15

dom__c,15

ffd_description_pb,Updated and spacious with private patio, huge storage/rec room and 2-car parking on ground floor; washer and dryer included, double pane windows, hardwood floor throughout, great natural light and walk-in closets. Sunken living room with wood burning fireplace, formal dining area and powder room on main level with sizable kitchen. 3 large bedrooms and 2 bathrooms with vaulted ceilings on top level. Great central location, with plenty of guest parking, walk to Forest Hill station, across the street from Midtown Terrace Playground, conveniently situated between Inner Sunset, Cole Valley and West Portal neighborhoods.

district__c,SF District 4

driveway_sidewalks__c,Paved Driveway

entry_level__c,0

external_listing__c,1

fireplace_features__c,Living Room;Wood Burning

pba__floortype_pb__c,Wood

hoa_fee_includes__c,Maintenance Grounds,Management,Sewer,Water

pba__hoafees__c,320

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2023-09-23T10:47:43.000+0000

pba__latitude_pb__c,37.7520159

pba__latitude_property__c,37.7520159

laundry_features__c,In Garage

listed_date__c,2023-07-29

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Kevin

pba__listing_agent_lastname__c,Wong

listing_agent_mls_id__c,803845

ffd_listingagentname,Kevin S Wong

listing_agent_number__c,166013108

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP

listing_office_name__c,Compass

listing_office_number__c,26293

pba__listingprice_pb__c,1385000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4572887

mls_id__c,423759722

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2023-09-08

open_house_end__c,2023-09-24T16:00:00.000+0000

open_house_start__c,2023-09-24T14:00:00.000+0000

original_price__c,1385000

overall_days_on_market__c,-81699

parking_access__c,Side by Side

parking_features__c,Attached

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,602.17

pba__propertytype__c,Single Family Residence

ListingId,a0E8W00000dSDiyUAG

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,2300

size__c,2300

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,Galewood

subdist__c,Forest Knolls

ffd_name,125 Galewood Circle, San Francisco, CA, 94131

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1979

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530660071-1.jpg

ffd_listing_title,341 Crestmont 343 Drive, San Francisco, CA, 94131

ffd_mls_id,423757833

ffd_salesforce_id,a0E8W00000bkwUlUAI

num_of_rooms__c,13

of_units__c,2

address2__c,341 Crestmont 343 Drive, San Francisco, CA, 94131

pba__address_pb__c,341 Crestmont 343 Drive, San Francisco, CA, 94131

agent_only_remarks__c,*Due to the lower level unit being gutted, conventional lending most likely will not be possible. *Supra lockbox location: go down stairs towards lower unit, first door to the right opens into utility hallway, directly behind the door, lockbox is on gas meters. *If showing the property, please be careful in lower unit as there are exposed wires and open floors. *Disclosures available at: https://app.disclosures.io/link/341343-Crestmont-Dr-i8qa8il9

appliances__c,Dishwasher;Gas Water Heater;Disposal;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator;See Remarks;Varies By Unit

architectural_style__c,Mid-Century

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,5

year_build_text__c,1964

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2023-07-21T19:50:03.000+0000

days_on_market__c,126

dom__c,110

ffd_description_pb,Located in Forest Knolls, this vacant 2 unit building is for someone looking for a project. Upper 2 level unit (341) is roughly 1,900 sqft with 3 beds on same level, 2.5 baths, remodeled kitchen, expansive main living area with a wall of windows affording amazing western views, a double sided wood burning fireplace and large family room. Also has 2 terraces, direct roof access, in-unit w/d and 1 car parking. The lower unit (343) has all ready been gutted to the studs and has a proposed floor plan with approx 970 sqft, 2 en-suite bedrooms, as well as a an open main living area, a large view deck, powder room, in-unit w/d and 1 car parking. The VIEWS abound on all 3 levels of the building: Golden Gate Heights, Goldenview Park, the Pacific Ocean, even a part of Golden Gate Park!! The quiet and serene location is right by a trail head for the Mount Sutro Open Space Reserve. This is the perfect fixer property for a handy person, developer, contractor, flipper... (Some photos showcase virtual staging and/or renovations)

district__c,SF District 4

external_listing__c,1

pba__floortype_pb__c,Bamboo;Carpet;Tile;See Remarks;Varies by Unit

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Fireplace(s);Natural Gas;Varies by Unit;See Remarks

interior_features__c,Skylight(s);Storage Area(s)

ffd_lastmodifieddate,2023-11-25T01:47:24.000+0000

pba__latitude_pb__c,37.757765

pba__latitude_property__c,37.757765

laundry_features__c,Laundry Closet;In Common Area;Washer/Dryer Owned;Varies by Unit

listed_date__c,2023-07-20

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Carlos

pba__listing_agent_lastname__c,Cabarcos

listing_agent_mls_id__c,806172

ffd_listingagentname,Carlos D Cabarcos

listing_agent_number__c,166016393

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,VANG02

listing_office_name__c,Vanguard Properties

listing_office_number__c,166013449

pba__listingprice_pb__c,1749000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.460695

mls_id__c,423757833

parkingspaces__c,2

on_market_date__c,2023-07-21

open_house_end__c,2023-11-26T15:00:00.000+0000

open_house_start__c,2023-11-26T13:00:00.000+0000

original_price__c,1995000

overall_days_on_market__c,-81650

parking_features__c,Attached,Garage,Garage Door Opener,Interior Access,Side-by-Side

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,0

pba__propertytype__c,Duplex

ListingId,a0E8W00000bkwUlUAI

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,0

size__c,0

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Crestmont

subdist__c,Forest Knolls

ffd_name,341 Crestmont 343 Drive, San Francisco, CA, 94131

view__c,Ocean;Park;Garden/Greenbelt;Hills;Woods

website_property_type__c,Duplex

pba__yearbuilt_pb__c,1964

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530650292-1.jpg

_yoast_indexnow_last_ping,1700878350