2245 Union 2247 Street, San Francisco, CA, 94123 - Property Description

_yoast_indexnow_last_ping,1721991438

ffd_listing_title,1501 Filbert Street #6A, San Francisco, CA, 94123

ffd_mls_id,424052300

ffd_salesforce_id,a0EUd000002fkVZMAY

num_of_fireplaces__c,0

num_of_rooms__c,6

of_units__c,27

address2__c,1501 Filbert Street #6A, San Francisco, CA, 94123

pba__address_pb__c,1501 Filbert Street #6A, San Francisco, CA, 94123

agent_only_remarks__c,Pre-escrow with Yvette Gonzalez at ORTC. Call LA to show by appointment.

appliances__c,Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Built-In Refrigerator

architectural_style__c,Modern/High Tech

bath_features__c,Tub w/Shower Over;Stone

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,2014

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-07-25T21:49:20.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,1501 Filbert, #6A is a luxurious two-bedroom plus den, two-bathroom, Cow Hollow condominium with quintessential City outlooks. Situated in the boutique Amero, the property offers floor-to-ceiling windows; an inviting open floor plan; private balcony; and chef's kitchen with Bertazzoni, Bosch, and Thermador appliances. Comfortably host gatherings, then relax in the luxurious primary suite. Soothing natural stone surfaces and an oversized rain-shower make the bath a retreat unto itself. The second bedroom, guest bath, and den make the space functional and flexible. Additional features include custom closets and window treatments, in-unit laundry, one-car parking, and storage. The professionally managed HOA offers a designer lobby and expansive rooftop terrace with Golden Gate Bridge and Bay views, built-in BBQs, fire pits, and ample seating. Sought-after Cow Hollow location provides easy access to Union, Chestnut, and Polk Streets, Fort Mason, Marina Green, and Crissy Field for dining, shopping, arts, and nature.

district__c,SF District 7

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Carpet;Wood;Stone

pba__hoafees__c,1007

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,0

has_3d_tour__c,1

has_monthly_parking_fees__c,1

interior_features__c,Elevator

ffd_lastmodifieddate,2024-07-26T10:48:10.000+0000

pba__latitude_pb__c,37.7991911

pba__latitude_property__c,37.7991911

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included

listed_date__c,2024-06-24

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jamie

pba__listing_agent_lastname__c,Lawrence

listing_agent_mls_id__c,807654

ffd_listingagentname,Jamie Lawrence

listing_agent_number__c,1023340

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

pba__listingtype__c,Sale

pba__listing_website__c,https://my.matterport.com/show/?m=1odLamvQjbG&mls=1

pba__longitude_pb__c,-122.4245164

mls_id__c,424052300

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

master_bathroom_features__c,Double Sinks;Stone;Multiple Shower Heads

master_property__c,a0O1I000001VikCUAS

monthly_parking_fees__c,52

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-07-25

open_house_end__c,2024-07-27T16:00:00.000+0000

open_house_start__c,2024-07-27T14:00:00.000+0000

original_price__c,1495000

overall_days_on_market__c,-82020

parking_access__c,Side by Side

parking_features__c,Assigned,Covered,Garage Door Opener,Interior Access

parking_type__c,On Site - Assigned (Condo 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,1225.41

pba__propertytype__c,Condominium

ListingId,a0EUd000002fkVZMAY

room_type__c,Den;Kitchen;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,1220

size__c,1220

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Filbert

subdist__c,Cow Hollow

ffd_name,1501 Filbert Street #6A, San Francisco, CA, 94123

view__c,San Francisco

website_property_type__c,Condominium

pba__yearbuilt_pb__c,2014

pba__postalcode_pb__c,94123

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1721904966

ffd_listing_title,2525 Van Ness Avenue #504, San Francisco, CA, 94109

ffd_mls_id,424051605

ffd_salesforce_id,a0EUd000002duvdMAA

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,28

address2__c,2525 Van Ness Avenue #504, San Francisco, CA, 94109

pba__address_pb__c,2525 Van Ness Avenue #504, San Francisco, CA, 94109

agent_only_remarks__c,Contact Frank Nolan for showings and DRE purchase agreement, 415.377.3726, [email protected]. www.belvederesf.com

appliances__c,Dishwasher;Disposal;Hood Over Range;Wine Refrigerator;Built-In Refrigerator;Gas Cook Top

architectural_style__c,Modern/High Tech

bath_features__c,Shower Stall(s);Tile;Quartz

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,2024

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2024-07-23T18:48:34.000+0000

days_on_market__c,2

dom__c,2

ffd_description_pb,Now 50% SOLD! The Belvedere, designed by world-renowned Handel Architects, is a culmination of elevated architectural design, tailor-made shared spaces, and 28 brand-new refined homes gracing San Francisco's prestigious Cow Hollow neighborhood. A concrete and steel structure built in 2024, The Belvedere features an exquisite, attended lobby, and incredible views captured from the two and three-bedroom homes spread across seven spacious levels. Crowning The Belvedere is an expansive, 6,200 sqft resort-style roof terrace with picture perfect views of the Golden Gate Bridge and San Francisco's most notable hills. The elegant kitchens include Miele appliances and gorgeous Gabana Quartzite stone, while the spa-like bathrooms are equipped with Waterworks fixtures and adorned in imported Calacatta stone. Additional features include: air conditioning, add'l storage available, and bicycle parking. Residence 504 is a 2 bed/2.5 bath 1,353 sqft home with a spacious great room with a formal dining area that can accommodate 6 people. The Belvedere is in a fantastic walking area, with the bustling shops, restaurants, and cafes of Union St in Cow Hollow right outside your door. Russian Hill, Pacific Heights, and The Marina are all just minutes away. Optional parking available.

district__c,SF District 7

driveway_sidewalks__c,Sidewalk/Curb/Gutter

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

pba__floortype_pb__c,Tile;Wood

hoa_fee_includes__c,Door Person,Elevator,Management,Trash

pba__hoafees__c,944

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,1

has_monthly_parking_fees__c,1

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2024-07-25T10:49:19.000+0000

pba__latitude_pb__c,37.7990113

pba__latitude_property__c,37.7990113

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included

listed_date__c,2024-07-23

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

pba__listingtype__c,Sale

pba__listing_website__c,https://www.belvederesf.com/

pba__longitude_pb__c,-122.424363

mls_id__c,424051605

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

master_property__c,a0OUd000002Ci7NMAS

monthly_parking_fees__c,85

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-07-23

open_house_end__c,2024-07-28T16:00:00.000+0000

open_house_start__c,2024-07-28T14:00:00.000+0000

original_price__c,1895000

overall_days_on_market__c,-82018

parking_access__c,Side by Side

parking_features__c,Enclosed,Garage Facing Front,Interior Access

parking_type__c,On Site - Assigned (Condo 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,1400.59

pba__propertytype__c,Condominium

ListingId,a0EUd000002duvdMAA

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Fire Suppression System;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,1353

size__c,1353

pba__state_pb__c,CA

stories__c,7

pba__street_pb__c,Van Ness

subdist__c,Cow Hollow

ffd_name,2525 Van Ness Avenue #504, San Francisco, CA, 94109

view__c,City

website_property_type__c,Condominium

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,2024

pba__postalcode_pb__c,94109

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1721869964

ffd_listing_title,1847 Filbert Street, San Francisco, CA, 94123

ffd_mls_id,424051118

ffd_salesforce_id,a0EUd000002cI61MAE

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,6

address2__c,1847 Filbert Street, San Francisco, CA, 94123

pba__address_pb__c,1847 Filbert Street, San Francisco, CA, 94123

appliances__c,Dishwasher

architectural_style__c,Edwardian;Traditional

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,1909

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-07-20T22:49:06.000+0000

days_on_market__c,4

dom__c,4

ffd_description_pb,This stunning top-floor Edwardian condominium perfectly blends period details with modern upgrades. Ideally located in the desirable Cow Hollow neighborhood between Union and Chestnut Streets, this home features hardwood floors, soaring coved ceilings, and a peekaboo view of the iconic Golden Gate Bridge. The property includes two bedrooms, one and a quarter baths (with the potential to convert the smaller bath to a full bathroom), and offers unparalleled convenience with a parking spot and storage unit that allow for easy drive-in and drive-out access. The entire building was retrofitted in 2022 to meet San Francisco's latest codes, ensuring extra security and peace of mind. Additionally, residents can enjoy a luscious and tranquil shared backyard. This supreme property is a harmonious blend of historical charm and contemporary comfort, perfectly situated in the vibrant Cow Hollow neighborhood.

district__c,SF District 7

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Wood

pba__hoafees__c,500

pba__hoafrequency_pb__c,Monthly

hoa_name__c,1843-1853 Filbert St. Homeowners Association

hoa__c,Yes

pba__halfbathrooms_pb__c,1

ffd_lastmodifieddate,2024-07-25T00:48:35.000+0000

pba__latitude_pb__c,37.7986315

pba__latitude_property__c,37.7986315

laundry_features__c,Washer/Dryer Stacked Included

listed_date__c,2024-07-08

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jeff

pba__listing_agent_lastname__c,Gray

listing_agent_mls_id__c,807677

ffd_listingagentname,Jeff Gray

listing_agent_number__c,1023767

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,WRWK

listing_office_name__c,Warwick Properties Group

listing_office_number__c,3024

pba__listingprice_pb__c,1595000

pba__listingtype__c,Sale

pba__listing_website__c,http://www.1847filbert.com

pba__longitude_pb__c,-122.4298894

mls_id__c,424051118

master_property__c,a0OUd000009nx9qMAA

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-07-20

open_house_end__c,2024-07-25T18:30:00.000+0000

open_house_start__c,2024-07-25T17:00:00.000+0000

original_price__c,1595000

overall_days_on_market__c,-82015

parking_access__c,Side by Side

parking_features__c,Enclosed,Garage Door Opener

parking_type__c,On Site - Assigned (Condo 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,1279.07

pba__propertytype__c,Condominium

ListingId,a0EUd000002cI61MAE

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

size__c,1247

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Filbert

subdist__c,Cow Hollow

ffd_name,1847 Filbert Street, San Francisco, CA, 94123

view__c,Golden Gate Bridge

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1909

pba__postalcode_pb__c,94123

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1722048912

ffd_listing_title,150 Pixley Street, San Francisco, CA, 94123

ffd_mls_id,424046180

ffd_salesforce_id,a0EUd000002ZO37MAG

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,3

address2__c,150 Pixley Street, San Francisco, CA, 94123

pba__address_pb__c,150 Pixley Street, San Francisco, CA, 94123

agent_only_remarks__c,Several different sq footage measurements; buyer to verify. No Showing Time Appointments please. Please call, email or text Natalie directly. Property Website: https://150pixley.com/mls

appliances__c,Dishwasher;Hood Over Range;Built-In Gas Oven;Built-In Refrigerator

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,1914

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Nina Hatvany

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2024-07-15T17:48:53.000+0000

days_on_market__c,11

dom__c,11

ffd_description_pb,Adorable Cow Hollow condominium in a fabulous location! Steps from Fillmore, Union and Chestnut Street shops and dining, tucked away on a tree-lined, one-way street. This full-floor flat has been renovated while preserving beautiful period details, including paneling, dark wood hardwood floors, wainscoting, moldings and more. Through a separate entrance and up a flight of stairs is an inviting eat-in kitchen equipped with deluxe stainless appliances including a Viking gas range, dishwasher, and side-by-side washer and dryer. Oversized windows facing the back of the building bring in streaming sunlight. Adjacent to the kitchen is an elegant formal dining room, furnished with a built-in cabinetry, a decorative fireplace, and box beam ceiling overhead. At the front of the flat is the lovely living room, with a bay window with plantation shutters and a decorative fireplace, and two generous bedrooms, both with California Closets. Off the hallway is an attractive marble bathroom with shower over tub. All this around the corner from the best of Cow Hollow and the Marina: great restaurants and nightlife, transportation, parks, the Presidio and the waterfront.

district__c,SF District 7

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Wood

hoa_fee_includes__c,Homeowners Insurance,Maintenance Exterior,Sewer,Trash,Water

pba__hoafees__c,836

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-07-27T02:46:45.000+0000

pba__latitude_pb__c,37.7986856

pba__latitude_property__c,37.7986856

laundry_features__c,In Kitchen;Washer Included;Dryer Included

listed_date__c,2024-07-15

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Natalie

pba__listing_agent_lastname__c,Kitchen

listing_agent_mls_id__c,400638

ffd_listingagentname,Natalie Kitchen

listing_agent_number__c,1021887

listing_co_agent_mls_id__c,372883

listing_co_agent_number__c,372883

listing_co_office_mls_id__c,COMP12

listing_co_office_name__c,Compass

listing_co_office_number__c,28739

listing_office_mls_id__c,COMP12

listing_office_name__c,Compass

listing_office_number__c,28739

pba__listingprice_pb__c,1395000

pba__listingtype__c,Sale

pba__listing_website__c,https://teamhatvany.com/

pba__longitude_pb__c,-122.4349569

mls_id__c,424046180

master_bathroom_features__c,Tub w/Shower Over;Marble

master_property__c,a0OUd000009Z5ywMAC

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,0

on_market_date__c,2024-07-15

open_house_end__c,2024-07-28T16:00:00.000+0000

open_house_start__c,2024-07-28T14:00:00.000+0000

original_price__c,1395000

overall_days_on_market__c,-82010

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

pba__propertytype__c,Condominium

ListingId,a0EUd000002ZO37MAG

room_type__c,Kitchen;Living Room;Dining Room;Possible Guest;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,1201

size__c,1201

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Pixley

subdist__c,Cow Hollow

ffd_name,150 Pixley Street, San Francisco, CA, 94123

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1914

pba__postalcode_pb__c,94123

ffd_media,Array

ffd_media_tags,Array

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