119 Stillings Avenue, San Francisco, CA, 94131 - Property Description

_yoast_indexnow_last_ping,1726764830

ffd_listing_title,2453 Diamond Street, San Francisco, CA, 94131

ffd_mls_id,424066618

ffd_salesforce_id,a0EUd0000039J89MAE

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,0

address2__c,2453 Diamond Street, San Francisco, CA, 94131

pba__address_pb__c,2453 Diamond Street, San Francisco, CA, 94131

appliances__c,Dishwasher;Gas Water Heater;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator;Ice Maker

architectural_style__c,Traditional

bath_features__c,Tub w/Shower Over;Tile;Low-Flow Toilet(s);Skylight/Solar Tube

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1947

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2024-09-19T15:46:51.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Discover the epitome of contemporary living in this impeccably remodeled single-level home. With 3 bedrooms & 2 bathrooms, this luxe residence offers a perfect blend of modern sophistication & comfort. Step into a newly redesigned kitchen featuring a sleek peninsula island, skylight, state-of-the-art appliances & dining area for six. The open layout seamlessly integrates with the living room, providing an ideal setting for both everyday living & entertaining. The primary suite is large, with walk-in closet & newly remodeled spa-like bathroom w/walk-in-shower, double sinks & custom tile work. The second bathroom has been thoughtfully updated w/contemporary finishes & fixtures, adding a touch of luxury. Enjoy the peace of mind that comes with new windows, updated electrical and plumbing systems & a brand-new roof. Designer lighting enhances the fresh interior and exterior paint, while the refinished hardwood floors exude timeless elegance. The front & rear yards have been meticulously landscaped & the rear yard offers a serene outdoor space for relaxation & entertaining. An interior atrium adorned with a captivating mural serves as a unique focal point within the home. Additional features include a 1-car garage, new water heater & washer/dryer.

district__c,SF District 5

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

entry_level__c,0

exterior_features__c,Entry Gate

external_listing__c,1

fencing__c,Back Yard

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

interior_features__c,Skylight(s)

ffd_lastmodifieddate,2024-09-19T16:47:12.000+0000

pba__latitude_pb__c,37.7389086

pba__latitude_property__c,37.7389086

laundry_features__c,In Garage;Washer Included;Dryer Included

listed_date__c,2024-09-01

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Alan

pba__listing_agent_lastname__c,Morcos

listing_agent_mls_id__c,804261

ffd_listingagentname,Alan Morcos

listing_agent_number__c,166013762

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP12

listing_office_name__c,Compass

listing_office_number__c,28739

pba__listingprice_pb__c,1495000

pba__listingtype__c,Sale

pba__listing_website__c,https://2453Diamond.com/mls

pba__longitude_pb__c,-122.4353362

mls_id__c,424066618

main_level__c,Full Bath(s);Bedroom(s);Kitchen;Living Room;Primary Bedroom

master_bathroom_features__c,Low-Flow Toilet(s);Double Sinks;Tile;Low-Flow Shower(s);Window;Multiple Shower Heads

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-09-19

open_house_end__c,2024-09-20T18:00:00.000+0000

open_house_start__c,2024-09-20T16:30:00.000+0000

original_price__c,1495000

overall_days_on_market__c,-82076

parking_access__c,Independent

parking_features__c,Attached,Covered,Enclosed,Garage Door Opener,Garage Facing Front,Interior Access

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Uncovered Patio

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000039J89MAE

roof__c,Bitumen

room_type__c,Kitchen;Atrium;Living Room;Primary Bathroom;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Security Gate;Carbon Mon Detector

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

size__c,1285

pba__state_pb__c,CA

stories__c,1

pba__street_pb__c,Diamond

subdist__c,Glen Park

ffd_name,2453 Diamond Street, San Francisco, CA, 94131

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,1947

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1726753946

ffd_listing_title,246 Bemis Street, San Francisco, CA, 94131

ffd_mls_id,424066187

ffd_salesforce_id,a0EUd0000039AmPMAU

num_of_rooms__c,10

of_units__c,3

address2__c,246 Bemis Street, San Francisco, CA, 94131

pba__address_pb__c,246 Bemis Street, San Francisco, CA, 94131

agent_only_remarks__c,Call Marcus Miller @ 415.516.5760 with questions, disclosures & private showings. 7/12/2024 Seller ready to sell. Can be shown by private appointment with listing agent Marcus Miller 415.516.5760 (Do NOT use Showing Time), with at least 24 hour notice, Mon-Fri. Cap Rate 5.19/GRM 13.80/Income $116,040/annually w/3 non-protected tenants. Offers as they come with signed-off disclosure package, which is available upon request. Virtually tour here > https://246-256bemis.com/. There is a CityStructure Feasibility Reports that shows adding ADU and expanding existing structur. Note: This property encroaches over vacant lot (256 Bemis St) and has a recorded easement over adjoining lot (256 - currently in contract, see disclosure package for details). Escrow Opened with Old Republic Title Co. Alethea Benally, 601 California St. Suite 900, SF, CA 415.421.9770 |[email protected]. Seller reserves the right to accept, counter or reject any offer that is presented.

appliances__c,Dishwasher;Disposal;Free Standing Gas Oven;Built-In Gas Oven;ENERGY STAR Qualified Appliances;Free Standing Refrigerator

architectural_style__c,Victorian;Bungalow

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,4

year_build_text__c,1908

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Ceiling Fan(s)

ffd_createddate,2024-09-19T10:50:46.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Looking for an investment property in coveted Glen Park, look no further than 246 Bemis Street, a 3-unit residential income property, which is a prime investment opportunity in a coveted A+ neighborhood near the Village. This unique property includes a 2-unit building in the front and a standalone cottage at the rear. Building Summary: Unit 246: 2BR/1BA with 1 car pad parking. Unit 246A: 1BR/1BA with city and bay views. Unit 246B: 1BR Open Floor plan/1BA plan cottage. All units feature hardwood floors, contemporary appliances, and dedicated laundry services (3). Each is separately metered for gas and electricity (PG&E). Additional Features: owner controlled 1-car garage with storage, potential for an ADU conversion. Full independent feasibility report available for building expansion. Currently fully tenant-occupied with great rents. Within walking distance to Glen Park's amenities, BART, and easy access to I-280/101. This property offers great income and room for expansion, making it an attractive investment. Can be shown by private appointment with listing agent.

district__c,SF District 5

electric__c,220 Volts

external_listing__c,1

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Wall Furnace

ffd_lastmodifieddate,2024-09-19T13:47:19.000+0000

pba__latitude_pb__c,37.7364156

pba__latitude_property__c,37.7364156

laundry_features__c,In Each Unit;Washer/Dryer Owned

listed_date__c,2023-06-12

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Marcus

pba__listing_agent_lastname__c,Miller

listing_agent_mls_id__c,803019

ffd_listingagentname,Marcus Miller

listing_agent_number__c,803019

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,HELM

listing_office_name__c,Helm Real Estate

listing_office_number__c,27303

pba__listingprice_pb__c,1698000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4320927

mls_id__c,424066187

parkingspaces__c,1

on_market_date__c,2024-09-19

original_price__c,1698000

overall_days_on_market__c,-82076

parking_features__c,Attached,Garage,Guest Parking Available

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,663.28

pba__propertytype__c,Triplex

ListingId,a0EUd0000039AmPMAU

roof__c,Shingle;Tile

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Double Strapped Water Heater

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

size__c,2560

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Bemis

subdist__c,Glen Park

ffd_name,246 Bemis Street, San Francisco, CA, 94131

view__c,Bay;Hills;Mt Diablo

website_property_type__c,Triplex

window_features__c,Window Coverings;Bay Window(s);Dual Pane Partial;Window Screens

pba__yearbuilt_pb__c,1908

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1726710932

ffd_listing_title,3 Mercato Court, San Francisco, CA, 94131

ffd_mls_id,424053110

ffd_salesforce_id,a0EUd0000036pJ4MAI

num_of_fireplaces__c,0

num_of_rooms__c,10

of_units__c,0

address2__c,3 Mercato Court, San Francisco, CA, 94131

pba__address_pb__c,3 Mercato Court, San Francisco, CA, 94131

agent_only_remarks__c,Disclosures linked here: https://app.disclosures.io/link/3-Mercato-Court-l9a1v6q9 Property is part of a neighborhood HOA- dues are $450/year.

appliances__c,Disposal;Hood Over Range;Free Standing Gas Range

architectural_style__c,Contemporary

bath_features__c,None

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,4

year_build_text__c,1977

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Colleen M Cotter

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2024-09-13T21:47:34.000+0000

days_on_market__c,5

dom__c,5

ffd_description_pb,3 Mercato Court is a rare opportunity to own a beautifully renovated 4 bedroom + den, 2.5 bathroom home located in the heart of Glen Park. This fully detached residence is situated on a serene cul-de-sac and offers outstanding panoramic views of the surrounding hillscape and San Francisco Bay. The main level of this spacious 3,625 square foot residence boasts an open floor plan. The living area features a fireplace and a wall of windows that provide stunning views and plenty of natural light, and opens directly onto a large balcony where you can further enjoy jaw-dropping vistas. The luxury chef's kitchen features custom cabinets, stainless steel appliances, and sleek quartz countertops, while the adjoining dining area provides the ideal place to enjoy meals with friends and family. The large primary ensuite bedroom can also be found on this level, and is home to a large walk-in closet and a spa-like bathroom. An office and an additional half bathroom complete the main level. One level below, you will find two additional spacious bedrooms and a full luxurious bathroom, along with another large balcony facing the San Francisco hills. The top floor of this home is the perfect place to relax, as it is home to a large recreation room with a wet bar, perfect for entertaining.

district__c,SF District 5

driveway_sidewalks__c,Paved Sidewalk

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

fencing__c,Back Yard

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,450

pba__hoafrequency_pb__c,Annually

hoa_name__c,Mira Glen Homeowners Association

hoa__c,Yes

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Central

interior_features__c,Cathedral Ceiling;Wet Bar

ffd_lastmodifieddate,2024-09-19T01:47:09.000+0000

pba__latitude_pb__c,37.7350861

pba__latitude_property__c,37.7350861

laundry_features__c,In Garage;Washer Included;Dryer Included

listed_date__c,2024-07-29

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Frank

pba__listing_agent_lastname__c,Nolan

listing_agent_mls_id__c,803037

ffd_listingagentname,Frank A Nolan

listing_agent_number__c,803037

listing_co_agent_mls_id__c,805388

listing_co_agent_number__c,166015298

listing_co_office_mls_id__c,VANG06

listing_co_office_name__c,Vanguard Properties

listing_co_office_number__c,25987

listing_office_mls_id__c,VANG02

listing_office_name__c,Vanguard Properties

listing_office_number__c,166013449

pba__listingprice_pb__c,2600000

pba__listingtype__c,Sale

pba__listing_website__c,https://www.3mercatocourt.com/

pba__longitude_pb__c,-122.4425643

lower_level__c,Bedroom(s),Full Bath(s),Garage,Street Entrance

mls_id__c,424053110

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

master_bathroom_features__c,Shower Stall(s);Double Sinks;Soaking Tub

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-09-13

open_house_end__c,2024-09-18T18:30:00.000+0000

open_house_start__c,2024-09-18T17:00:00.000+0000

original_price__c,2600000

overall_days_on_market__c,-82070

parking_access__c,Side by Side

parking_features__c,Attached,Garage Door Opener,Interior Access

parking_type__c,On Site (Single Family Only)

pba__pendingdate__c,1800-01-01

possible_bedrooms__c,0

pba__pricechangedat__c,2024-09-13T14:02:55.000+0000

price_per_square_foot__c,704.61

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000036pJ4MAI

room_type__c,Living Room;Primary Bathroom;Primary Bedroom

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

size__c,3690

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Mercato

subdist__c,Glen Park

ffd_name,3 Mercato Court, San Francisco, CA, 94131

view__c,City;Downtown;Hills;Canyon

website_property_type__c,Single Family Home

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/530828618-1.jpg

_yoast_indexnow_last_ping,1726275471

ffd_listing_title,21 Everson Street, San Francisco, CA, 94131

ffd_mls_id,424064679

ffd_salesforce_id,a0EUd0000036UOJMA2

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,0

address2__c,21 Everson Street, San Francisco, CA, 94131

pba__address_pb__c,21 Everson Street, San Francisco, CA, 94131

agent_only_remarks__c,Contact Frank Nolan with inquiries, 415.377.3726, [email protected]. www.21Everson.com

appliances__c,Dishwasher;Disposal;Hood Over Range;Free Standing Gas Range;Wine Refrigerator;Double Oven;Built-In Refrigerator

architectural_style__c,Modern/High Tech

bath_features__c,Shower Stall(s);Tub;Double Sinks;Window

pba__fullbathrooms_pb__c,6

pba__bedrooms_pb__c,6

year_build_text__c,0

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Central,MultiZone

ffd_createddate,2024-09-13T17:46:52.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Secluded in the gently rolling hills of Glen Park and molded into the terrain, 21 Everson St is a modern, architecturally significant fortress with an incomparable 60-foot wide main level that captures stunning San Francisco and bay views. This custom built home by Design Line Construction and designed by Studio Graf boasts 6 en-suite bedrooms, 9 bathrooms, 9,704 sqft (per architect) with a guest suite. A remarkable 1,000 sqft professional-grade theater sits at the base of the home, boasting Dolby Atmos surround sound, dual Sony 4k projectors, commercial-grade insulation, and seating for 22+ people. Upon entering the home through the double-height foyer, you are greeted with a 2,300 sqft main level with floor to ceiling sliding glass doors, creating an immersive indoor-outdoor experience. Levitating over the city with sweeping views, the impressive primary suite is on the top level and is flanked by two guest bedrooms. The two lower levels of the home include additional guest bedrooms, family room with terrace, wine room, and guest suite which provides access to the lush landscaped garden. Additional features: roof deck with BBQ, Savant home automation, Lutron lighting, 2 car garage with EV charger, reverse osmosis drinking water, in-floor radiant heat & air conditioning.

district__c,SF District 5

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk,Sidewalk/Curb/Gutter

entry_level__c,0

exterior_features__c,Entry Gate;BBQ Built-In;Fire Pit

external_listing__c,1

fencing__c,Back Yard

fireplace_features__c,Living Room;Gas Piped

pba__floortype_pb__c,Carpet;Concrete;Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,3

pba__heatingtype_pb__c,Radiant Floor;MultiZone

interior_features__c,Formal Entry;Skylight(s);Storage Area(s);Cathedral Ceiling;Wet Bar

ffd_lastmodifieddate,2024-09-14T00:47:20.000+0000

pba__latitude_pb__c,37.7383842

pba__latitude_property__c,37.7383842

laundry_features__c,Inside Room;Washer/Dryer Stacked Included

listed_date__c,2024-09-13

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Frank

pba__listing_agent_lastname__c,Nolan

listing_agent_mls_id__c,803037

ffd_listingagentname,Frank A Nolan

listing_agent_number__c,803037

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

pba__listingtype__c,Sale

pba__listing_website__c,https://www.21everson.com/

pba__longitude_pb__c,-122.4295161

lower_level__c,Bedroom(s),Family Room,Full Bath(s),Kitchen,Partial Bath(s)

mls_id__c,424064679

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

master_bathroom_features__c,Shower Stall(s);Double Sinks;Soaking Tub;Window;Steam

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-09-13

original_price__c,19995000

overall_days_on_market__c,-82070

parking_access__c,Side by Side

parking_features__c,Enclosed,EV Charging,Garage Door Opener,Garage Facing Front,Interior Access,Side-by-Side

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Roof Deck;Uncovered Deck;Covered Deck

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000036UOJMA2

room_type__c,Storage;Family Room;Wine Storage Area;Temp Controlled Room;Home Theater

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Fire Suppression System;Carbon Mon Detector;Video System

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

size__c,9704

pba__state_pb__c,CA

stories__c,4

pba__street_pb__c,Everson

subdist__c,Glen Park

ffd_name,21 Everson Street, San Francisco, CA, 94131

view__c,Panoramic;City Lights;Bay;San Francisco;Mountains

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,0

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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