ffd_listing_title,25 Rico Way, San Francisco, CA, 94123

ffd_mls_id,423910312

ffd_salesforce_id,a0E8W00000dTSLJUA4

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,0

address2__c,25 Rico Way, San Francisco, CA, 94123

pba__address_pb__c,25 Rico Way, San Francisco, CA, 94123

agent_only_remarks__c,25Rico.com Please view our property website above and share with your clients. For more information or to schedule a private tour, please contact Gregg Lynn at [email protected] or 415.595.4734

appliances__c,Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Built-In Gas Oven;Built-In BBQ;Wine Refrigerator;Double Oven;Ice Maker;Built-In Refrigerator;Plumbed For Ice Maker;Built-In Electric Oven;Warming Drawer;Gas Plumbed

architectural_style__c,Marina;Modern/High Tech

bath_features__c,Shower Stall(s);Tub;Tile;Low-Flow Toilet(s);Radiant Heat;Window;Stone

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,3

year_build_text__c,0

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-09-22T02:46:46.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Behind the striking facade on one of the city's most desirable streets lies the ground-up rebuild of 25 Rico, unrivaled for its high-caliber construction & pursuit of perfection. Fully reimagined by Sutton Suzuki Architects & Hadley Construction, the home features infrastructure & technology programs that redefine the new luxury of style & function. With 11-foot ceilings, glass walls & earth-toned accents, the home begins at the living room with a fireplace of oversized stone & steel surround. Entertain smartly in the kitchen of Neolith stone, quartz counters, architectural millwork, butler's pantry & La Cornue stove. The dining room features a custom Apparatus chandelier & large windows to the garden. A level above lies the primary suite with a stylish bath, walk-in closet & terrace. An additional bedroom, bath & office nook share this level. The rooftop terrace premium infrastructure includes a firebox to enjoy Alcatraz & the Golden Gate. The lower level combines a third bed & bath, wine storage, laundry room & southern garden highlighted by onyx with fire & water features. The garage details ample storage & two Tesla Powerwalls for backup. The elevator accesses all interior floors while Control4 provides device-control of climate, lighting, shades, media/AV, security, & more.

district__c,SF District 7

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

electric__c,Battery Backup,Photovoltaics Seller Owned

entry_level__c,0

exterior_features__c,Balcony;Fireplace;BBQ Built-In;Fire Pit

external_listing__c,1

fencing__c,Back Yard

fireplace_features__c,Living Room;Gas Piped;Raised Hearth

pba__floortype_pb__c,Concrete;Tile;Wood;Stone

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Radiant Floor;Fireplace(s)

ffd_lastmodifieddate,2023-09-22T02:46:46.000+0000

pba__latitude_pb__c,37.804664

pba__latitude_property__c,37.804664

laundry_features__c,Inside Room;Washer/Dryer Stacked Included;Cabinets;Sink

listed_date__c,2023-07-07

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Gregg

pba__listing_agent_lastname__c,Lynn

listing_agent_mls_id__c,804728

ffd_listingagentname,Gregg Lynn

listing_agent_number__c,166014390

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,STHB

listing_office_name__c,Sotheby's International Realty

listing_office_number__c,2050

pba__listingprice_pb__c,7900000

pba__listingtype__c,Sale

pba__listing_website__c,https://youtu.be/u0M5jHJ5ZCA

pba__longitude_pb__c,-122.438711

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

mls_id__c,423910312

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

master_bathroom_features__c,Shower Stall(s);Low-Flow Toilet(s);Quartz;Double Sinks;Tile;Radiant Heat;Multiple Shower Heads

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-09-21

original_price__c,7900000

overall_days_on_market__c,-81712

parking_access__c,Independent

parking_features__c,Attached,Enclosed,EV Charging,Garage Door Opener,Garage Facing Front,Interior Access,Workshop in Garage

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Roof Deck;Uncovered Deck;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,2194.44

pba__propertytype__c,Single Family Residence

ListingId,a0E8W00000dTSLJUA4

room_type__c,Laundry;Kitchen;Library;Living Room;Baths Other;Dining Room;Possible Guest;Wine Storage Area;Primary Bathroom;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Fire Alarm;Carbon Mon Detector;Video System;Security System Prewired;Security System Owned;Other

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

size__c,3600

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,Rico

subdist__c,Marina

ffd_name,25 Rico Way, San Francisco, CA, 94123

website_property_type__c,Single Family Home

window_features__c,Window Coverings

pba__yearbuilt_pb__c,0

pba__postalcode_pb__c,94123

ffd_media,Array

ffd_media_tags,Array

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

ffd_listing_title,3133 Franklin Street, San Francisco, CA, 94123

ffd_mls_id,423909629

ffd_salesforce_id,a0E8W00000dSfjkUAC

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,2

address2__c,3133 Franklin Street, San Francisco, CA, 94123

pba__address_pb__c,3133 Franklin Street, San Francisco, CA, 94123

agent_only_remarks__c,NOT on landfill. Offers on latest SFAR PA only. Sale is by a Trust with escrow opened with Mijael Schmidt at First Am. Seller requests to keep escrow there. Pay as you go informal HOA.

appliances__c,Dishwasher;Free Standing Gas Range;Built-In Gas Oven;Free Standing Refrigerator

architectural_style__c,Marina;Traditional;Mediterranean

bath_features__c,Tile;Radiant Heat

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1922

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-09-18T10:47:56.000+0000

days_on_market__c,3

dom__c,3

ffd_description_pb,Location. Scale. Light. 3133 Franklin impresses with its command of all three. Steps from the quiet end of Franklin St., it's a short walk to iconic spots like the Marina, Fisherman's Wharf, Fort Mason and Aquatic Park, yet this exquisite home radiates a gracious calm. The living room, in classic Marina-style, spans the building's width and features four stunning Mediterranean arched windows. Adjacent is a formal dining room leading to a chef's kitchen outfitted with quality maple cabinets, stone countertops, and high-end appliances, including a Viking range. The bedrooms are at a generous remove from the public areas. Two luminous primary BRs, nearly identical in size, each have their own sun room/office and overlook a peaceful shared patio. A third sits centrally off the long gallery hallway. Bathrooms are tastefully renovated. The first, an ensuite, serves one of the primary BRs. The second, with dual access to both the other primary BR and the hallway, is appointed with heated tile floors. Generous closet space is available throughout. Additional amenities include parking at least two cars with direct access from the unit, a shared wine cellar, laundry room (plus in-unit hook-up), and extensive garage storage.

district__c,SF District 7

entry_level__c,0

external_listing__c,1

fireplace_features__c,Living Room

pba__floortype_pb__c,Tile;Wood

hoa_fee_includes__c,Common Areas,Insurance

pba__hoafees__c,0

hoa_name__c,3133-3135 Franklin Street Homeowners Association

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Steam

interior_features__c,Formal Entry

ffd_lastmodifieddate,2023-09-22T01:47:01.000+0000

pba__latitude_pb__c,37.803468

pba__latitude_property__c,37.803468

laundry_features__c,In Garage;Hookups Only;Washer Included;Dryer Included

listed_date__c,2023-08-23

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Misha

pba__listing_agent_lastname__c,Weidman

listing_agent_mls_id__c,245016

ffd_listingagentname,Misha D Weidman

listing_agent_number__c,245016

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP7

listing_office_name__c,Compass

listing_office_number__c,28751

pba__listingprice_pb__c,2500000

pba__listingtype__c,Sale

pba__listing_website__c,http://www.3133franklin.com/mls/114765011

pba__longitude_pb__c,-122.426978

mls_id__c,423909629

master_bathroom_features__c,Low-Flow Toilet(s);Tile

master_property__c,a0O8W00000EY7EZUA1

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2023-09-18

open_house_end__c,2023-09-21T18:30:00.000+0000

open_house_start__c,2023-09-21T16:30:00.000+0000

original_price__c,2500000

overall_days_on_market__c,-81709

parking_access__c,Side by Side

parking_features__c,Attached,Garage Facing Front,Side-by-Side,Tandem Garage

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

pba__propertytype__c,Condominium

ListingId,a0E8W00000dSfjkUAC

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

size__c,2223

pba__state_pb__c,CA

stories__c,1

pba__street_pb__c,Franklin

subdist__c,Marina

ffd_name,3133 Franklin Street, San Francisco, CA, 94123

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1922

pba__postalcode_pb__c,94123

ffd_media,Array

ffd_media_tags,Array

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

ffd_listing_title,3472 Scott Street, San Francisco, CA, 94123

ffd_mls_id,423907888

ffd_salesforce_id,a0E8W00000dSXzEUAW

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,2

address2__c,3472 Scott Street, San Francisco, CA, 94123

pba__address_pb__c,3472 Scott Street, San Francisco, CA, 94123

agent_only_remarks__c,48 Hours notice required for showings Monday-Friday 9am-5pm. Tenants are a family with childern in school. No owner move in will happen at close of escrow. ** Photos in MLS are from sale when seller purchased in 2012** Offers reviewed as they are presented.

appliances__c,Dishwasher;Disposal;Hood Over Range;Free Standing Gas Range;ENERGY STAR Qualified Appliances;Free Standing Refrigerator;Ice Maker

architectural_style__c,Marina

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,1925

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-09-16T10:47:27.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Picture perfect living in the heart of the Marina. Renovated TOP FLOOR 2BR/2BA condo & roof deck with Golden Gate Bridge views.The home was taken to the studs in 2012 with a spacious open floor plan living with a chef's dream kitchen. Includes stainless steel appliances featuring Viking range, caesar stone counters & custom hood. Hardwood floors, recessed lighting, Washer & Dryer in unit. One bedroom has a balcony. Primary bedroom has an ensuite with 2nd bath. Enclosed staircase off the kitchen leads to a spacious roof deck. Independent 1 car parking + storage. Walk a few blocks to Crissy Field, Palace of Fine Arts, or Chestnut Street. This is Tenant occuipied & showings are by appointment Monday-Friday 9am-5pm with 48 hours notice. Condo will be sold with Tenants.

district__c,SF District 7

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa_name__c,3470-3472 Scott Strett

hoa__c,Yes

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2023-09-16T13:46:04.000+0000

pba__latitude_pb__c,37.802172

pba__latitude_property__c,37.802172

laundry_features__c,Washer Included;Dryer Included

listed_date__c,2023-09-07

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Monica

pba__listing_agent_lastname__c,Pauli

listing_agent_mls_id__c,802345

ffd_listingagentname,Monica M Pauli

listing_agent_number__c,802345

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.441291

mls_id__c,423907888

master_bathroom_features__c,Tub w/Shower Over

master_property__c,a0O8W00000KTNbKUAX

monthly_parking_fees__c,0

monthlyrent__c,6742

parkingspaces__c,1

on_market_date__c,2023-09-16

open_house_end__c,2023-09-19T12:00:00.000+0000

open_house_start__c,2023-09-19T10:00:00.000+0000

original_price__c,1795000

overall_days_on_market__c,-81707

parking_access__c,Side by Side

parking_features__c,Side-by-Side

parking_type__c,On Site - Mapped (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,1132.49

pba__propertytype__c,Condominium

ListingId,a0E8W00000dSXzEUAW

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;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,1585

size__c,1585

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Scott

subdist__c,Marina

ffd_name,3472 Scott Street, San Francisco, CA, 94123

view__c,Golden Gate Bridge

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1925

pba__postalcode_pb__c,94123

ffd_media,Array

ffd_media_tags,Array

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

ffd_listing_title,805 Marina Boulevard, San Francisco, CA, 94123

ffd_mls_id,423907077

ffd_salesforce_id,a0E8W00000cqNq5UAE

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,0

address2__c,805 Marina Boulevard, San Francisco, CA, 94123

pba__address_pb__c,805 Marina Boulevard, San Francisco, CA, 94123

agent_only_remarks__c,Front row! Beautiful views of the Bay. Huge roof deck with pent room. Wonderful entertaining home. Big chef's kitchen. 2 car garage. Please call Max Armour 415-290-6058. Thanks!

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

architectural_style__c,Mediterranean

bath_features__c,Tub w/Shower Over;Tub;Stone

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,4

year_build_text__c,1936

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-09-06T22:46:50.000+0000

days_on_market__c,15

dom__c,15

ffd_description_pb,There is only one Marina Blvd. This incredibly unique and beautiful street has a front-row seat to the glistening waters of the San Francisco Bay. With unobstructed views, 805 Marina Blvd provides the quintessential California lifestyle. Walk across the street to Crissy Field Beach, St Francis Yacht Club, Marina Green, Palace of Fine Arts, and Golden Gate National Recreation Area. This 4BD, 3 Full BA, 2 Half BA updated single-family home has a great entertaining flow and family layout. One of the main highlights is a pent room with a huge rear roof deck with views of the City and Palace of Fine Arts and a Bay view walkout front deck. The chef's kitchen includes a large center island, two ovens, two dishwashers, two sinks and custom cabinetry. There is a gracious dining/family room and a formal living room with water views and fireplace. The primary suite offers sublime views of the Bay and Alcatraz along with a generous en-suite bath and extra large walk-in closet. The additional bedrooms are light-filled and gracious sizes. 2 car garage, laundry room, en-suite guest quarters, and flat back yard complete the home.

district__c,SF District 7

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

fencing__c,Back Yard

fireplace_features__c,Living Room;Wood Burning

pba__floortype_pb__c,Marble;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,2

pba__heatingtype_pb__c,Radiant;Steam;Central;Gas;Natural Gas

interior_features__c,Formal Entry;Wet Bar

ffd_lastmodifieddate,2023-09-22T02:46:31.000+0000

pba__latitude_pb__c,37.8048961

pba__latitude_property__c,37.8048961

laundry_features__c,Ground Floor;Washer Included;Dryer Included

listed_date__c,2023-09-06

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Maximillian

pba__listing_agent_lastname__c,Armour

listing_agent_mls_id__c,804422

ffd_listingagentname,Maximillian Armour

listing_agent_number__c,166013971

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

pba__listingtype__c,Sale

pba__listing_website__c,http://www.805marinasf.com

pba__longitude_pb__c,-122.447462

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

mls_id__c,423907077

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

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

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2023-09-06

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

overall_days_on_market__c,-81697

parking_access__c,Tandem

parking_features__c,Attached,Garage Door Opener,Interior Access,Tandem Garage

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Roof 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,1396.58

pba__propertytype__c,Single Family Residence

ListingId,a0E8W00000cqNq5UAE

room_type__c,Bonus Room;Laundry;Kitchen;Living Room;Dining Room;Family Room;Primary Bathroom

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

size__c,3505

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Marina

subdist__c,Marina

ffd_name,805 Marina Boulevard, San Francisco, CA, 94123

view__c,City;City Lights;Garden/Greenbelt;Bay;Water;Mt Tamalpais

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full;Triple Pane Partial

pba__yearbuilt_pb__c,1936

pba__postalcode_pb__c,94123

ffd_media,Array

ffd_media_tags,Array

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