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

_yoast_indexnow_last_ping,1726282674

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 will be linked here when available. 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,0

dom__c,0

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 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-14T02:46:43.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-14T16:00:00.000+0000

open_house_start__c,2024-09-14T14: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

_yoast_indexnow_last_ping,1726235565

ffd_listing_title,1784 Dolores Street, San Francisco, CA, 94110

ffd_mls_id,424065082

ffd_salesforce_id,a0EUd0000036H4TMAU

num_of_rooms__c,12

of_units__c,4

address2__c,1784 Dolores Street, San Francisco, CA, 94110

pba__address_pb__c,1784 Dolores Street, San Francisco, CA, 94110

agent_only_remarks__c,Please email or call Rachel Abraham-Pollard to schedule a showing or for more information. [email protected] or 415.828.3964

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,4

year_build_text__c,1953

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-13T10:50:11.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,1784 Dolores is a four-unit investment property in Noe Valley. The building consists of four charming and practical one-bedroom apartments. The units have hardwood floors, great natural light, and most have been nicely updated. One unit will be delivered vacant. The building is separately metered for gas and electricity, and heat is supplied via wall heaters, so operating expenses are very low. The garage can accommodate three cars, but is currently used for two cars only.. There are storage closets for each apartment in the garage, as well as coin operated laundry. The building has been maintained to a high-standard throughout, providing a turn-key investment opportunity for a new owner. This excellent location provides tenants with access to the best of Noe Valley, Mission, Glen Park, and Bernal Heights. Public transportation and freeway access are also very convenient.

district__c,SF District 5

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-09-13T13:46:24.000+0000

pba__latitude_pb__c,37.7409851

pba__latitude_property__c,37.7409851

laundry_features__c,Coin Operated

listed_date__c,2024-09-12

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Adam

pba__listing_agent_lastname__c,Filly

listing_agent_mls_id__c,803097

ffd_listingagentname,Adam D Filly

listing_agent_number__c,803097

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP13

listing_office_name__c,Compass Commercial

listing_office_number__c,27689

pba__listingprice_pb__c,1600000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4244558

mls_id__c,424065082

parkingspaces__c,3

on_market_date__c,2024-09-13

open_house_end__c,2024-09-17T14:00:00.000+0000

open_house_start__c,2024-09-17T12:00:00.000+0000

original_price__c,1600000

overall_days_on_market__c,-82070

parking_features__c,Garage

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,526.32

pba__propertytype__c,Quadruplex

ListingId,a0EUd0000036H4TMAU

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

size__c,3040

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Dolores

subdist__c,Glen Park

ffd_name,1784 Dolores Street, San Francisco, CA, 94110

website_property_type__c,Quadruplex

pba__yearbuilt_pb__c,1953

pba__postalcode_pb__c,94110

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1726264558

ffd_listing_title,149 Laidley Street, San Francisco, CA, 94131

ffd_mls_id,424056815

ffd_salesforce_id,a0EUd0000036H2sMAE

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,0

address2__c,149 Laidley Street, San Francisco, CA, 94131

pba__address_pb__c,149 Laidley Street, San Francisco, CA, 94131

agent_only_remarks__c,Pre-Escrow opened with First American Title. Disclosures linked to MLS or download here: https://app.disclosures.io/link/149-Laidley-Street-7okl35za. For private showings and additional information please contact [email protected] / 415.935.1014.

architectural_style__c,Contemporary;Victorian

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1900

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-13T10:47:14.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Discover 149 Laidley, a gem in Fairmount Heights, blending a Victorian facade with a modern interior for the ultimate living experience. The entrance reveals a spacious living room with soaring ceilings and wall-to-wall windows offering stunning city views! A walk-out deck reveals a vast panorama, perfect for relaxation and entertaining. The open-concept floor plan boasts a remodeled eat-in kitchen with dining island that effortlessly flows into the dining and living areas. Spanning three levels, each room is designed for comfort and style. The master suite, a haven with an en-suite bath and private deck, is spacious enough for a home office or lounge. The second bedroom has easy access to a modern bathroom, and the third bedroom is a versatile space opening to a sunny rear yard. With access to Glen Park and Noe Valley an abundance of local shops, eateries, parks, and public transportation awaits. 149 Laidley is a blend of historic elegance and modern living, a perfect urban home.

district__c,SF District 5

entry_level__c,0

exterior_features__c,Balcony;Fire Pit

external_listing__c,1

fencing__c,Fenced

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

interior_features__c,Cathedral Ceiling;Open Beam Ceiling

ffd_lastmodifieddate,2024-09-13T21:47:08.000+0000

pba__latitude_pb__c,37.7395867

pba__latitude_property__c,37.7395867

laundry_features__c,Laundry Closet;Washer Included;Dryer Included

listed_date__c,2024-08-13

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jason

pba__listing_agent_lastname__c,Hoffman

listing_agent_mls_id__c,807419

ffd_listingagentname,Jason H Hoffman

listing_agent_number__c,1017981

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

pba__listingtype__c,Sale

pba__listing_website__c,https://www.149laidley.com

pba__longitude_pb__c,-122.4289608

lower_level__c,Bedroom(s),Family Room

mls_id__c,424056815

main_level__c,Kitchen;Living Room;Dining Room;Family Room;Street Entrance

master_bathroom_features__c,Double Sinks

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,0

on_market_date__c,2024-09-13

open_house_end__c,2024-09-15T16:00:00.000+0000

open_house_start__c,2024-09-15T14:00:00.000+0000

original_price__c,2495000

overall_days_on_market__c,-82070

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000036H2sMAE

room_type__c,Laundry;Kitchen;Dining Room;Family 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,2404

size__c,2404

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Laidley

subdist__c,Glen Park

ffd_name,149 Laidley Street, San Francisco, CA, 94131

view__c,City;Panoramic;City Lights;Bay;Downtown;Bay Bridge;San Francisco;Bridges

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1900

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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