225 Mallorca Way, San Francisco, CA, 94123 - Property Description

_yoast_indexnow_last_ping,1725965666

ffd_listing_title,3208 Pierce Street #404, San Francisco, CA, 94123

ffd_mls_id,424050574

ffd_salesforce_id,a0EUd0000034HBqMAM

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,16

address2__c,3208 Pierce Street #404, San Francisco, CA, 94123

pba__address_pb__c,3208 Pierce Street #404, San Francisco, CA, 94123

agent_only_remarks__c,Selling willing to consider concessions. For showing requests, please contact Cristian Isbrandtsen 415.535.9850 ([email protected])

appliances__c,Dishwasher;Microwave;Built-In Gas Range;Built-In Refrigerator

architectural_style__c,Contemporary

bath_features__c,Tub w/Shower Over

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,2007

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Cristian Isbrandtsen

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2024-09-10T00:47:34.000+0000

days_on_market__c,53

dom__c,49

ffd_description_pb,Stunning top-floor condo steps away from Chestnut Street in the sought-after Marina District. With its corner location and abundant natural light, this unit offers a modern and airy home suitable for entertaining and relaxation. This 2 bedroom, 1.5 bath home features high ceilings, wide plank flooring, multiple balconies, beautiful outlooks, and partial Golden Gate Bridge views. The kitchen has newer appliances with counter seating while the fireplace adds a cozy touch. The spacious primary suite has a private balcony and custom closets. The second bedroom offers a flexible layout, ideal for a guest bedroom or home office. Additional amenities include an in-unit washer/dryer, large private storage room, one-car parking, elevator access, and a serene shared courtyard. Located within walking distance to Union Street restaurants & shops, The Presidio, Fort Mason, and Crissy Field, this condo is the perfect blend of modern design and urban convenience.

district__c,SF District 7

entry_level__c,0

exterior_features__c,Balcony;Uncovered Courtyard

external_listing__c,1

fireplace_features__c,Living Room;Gas Log

pba__floortype_pb__c,Carpet;Tile;Wood

hoa_fee_includes__c,Common Areas,Elevator,Insurance,Insurance on Structure,Maintenance Exterior,Management,Trash,Water

pba__hoafees__c,908

pba__hoafrequency_pb__c,Monthly

hoa_name__c,2298 Lombard Owners Association

hoa__c,Yes

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Wall Furnace;Fireplace(s)

interior_features__c,Skylight(s)

ffd_lastmodifieddate,2024-09-10T10:48:59.000+0000

pba__latitude_pb__c,37.7996894

pba__latitude_property__c,37.7996894

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included

listed_date__c,2024-07-17

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Paul

pba__listing_agent_lastname__c,Warrin

listing_agent_mls_id__c,803577

ffd_listingagentname,Paul Warrin

listing_agent_number__c,803577

listing_co_agent_mls_id__c,818740

listing_co_agent_number__c,1077451

listing_co_office_mls_id__c,DECK

listing_co_office_name__c,Golden Gate Sotheby's International Realty

listing_co_office_number__c,959

listing_office_mls_id__c,DECK10

listing_office_name__c,Golden Gate Sotheby's International Realty

listing_office_number__c,28264

pba__listingprice_pb__c,1199000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4392652

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

mls_id__c,424050574

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

master_property__c,a0O1I000001ViSuUAK

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-07-19

original_price__c,1199000

overall_days_on_market__c,-82014

parking_access__c,Independent

parking_features__c,Attached,Covered,Enclosed,Garage Door Opener,Interior Access,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,1016.1

pba__propertytype__c,Condominium

ListingId,a0EUd0000034HBqMAM

room_type__c,Living Room;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Secured Access;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,1180

size__c,1180

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Pierce

subdist__c,Marina

ffd_name,3208 Pierce Street #404, San Francisco, CA, 94123

view__c,City;Golden Gate Bridge;Bridges

website_property_type__c,Condominium

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,2007

pba__postalcode_pb__c,94123

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1725882890

ffd_listing_title,278 Avila Street, San Francisco, CA, 94123

ffd_mls_id,424058405

ffd_salesforce_id,a0EUd0000033NcfMAE

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,0

address2__c,278 Avila Street, San Francisco, CA, 94123

pba__address_pb__c,278 Avila Street, San Francisco, CA, 94123

agent_only_remarks__c,Escrow opened with Chicago Title Co, Pauline Thach, Escrow #FWPN-3542400605-PT. (415) 405-1313. Offers will be reviewed as they come. Please submit offer with disclosure signed off by buyers. Disclosure IO link as follow:https://app.disclosures.io/link/278-Avila-Street-g1xqob0j Any offers allow 2 to 3 days response time due to seller is out of country. Seller may or may not rent back for 10 days after close of escrow.

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

bath_features__c,Low-Flow Toilet(s);Low-Flow Shower(s)

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,4

year_build_text__c,1926

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-07T02:47:54.000+0000

days_on_market__c,22

dom__c,15

ffd_description_pb,Welcome to this charming home situated at 278 Avila St which is one of the best areas in the heart of Marina district. It is located 4 blocks to the Palace of Fine Art, 3 blocks to the Natural beauty of Marina Green with bay view, A short walk to Chestnut Street boutique shops and restaurants. Owning this home, living in such a peaceful, comfortable and serene environment is everyone's life dream. This home features total of 4 bedrooms, 3 bathrooms, 2 Sunrooms and 1 family room. Upper level boasts a spacious living room with customized window coverings and a fireplace; a large dining room and a large remodeled (2004) kitchen with a breakfast nook. There are 2 bright, large bedrooms, 1 bath and one sunroom with skylight to the rear of this level. Lower level offers a family room (or Den), 2 additional bedrooms, 2 baths, 1 sunroom including a master suite. A serene private backyard garden, a laundry closet and a spacious 1 car garage add the finishing touch to this exceptional home with Pride of Ownership. The building Sq Ft (living area) per property detail was 1640 sf. The completion of ground floor remodeling as shown on plan #9404655 in 1995 added 957 sf to the total of 2597 sf of living area. Buyers urged to investigate to their satisfaction before making offer.

district__c,SF District 7

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

fireplace_features__c,Other

pba__floortype_pb__c,Tile;Vinyl;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

interior_features__c,Formal Entry

ffd_lastmodifieddate,2024-09-09T11:47:08.000+0000

pba__latitude_pb__c,37.8036135

pba__latitude_property__c,37.8036135

laundry_features__c,Laundry Closet;Washer Included;Dryer Included

listed_date__c,2024-08-03

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Hamlet

pba__listing_agent_lastname__c,Yu

listing_agent_mls_id__c,088112

ffd_listingagentname,Hamlet C Yu

listing_agent_number__c,88112

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,ORIB

listing_office_name__c,Coldwell Banker Infiniti Group

listing_office_number__c,1635

pba__listingprice_pb__c,3538000

pba__listingtype__c,Sale

pba__listing_website__c,http://278avila.com

pba__longitude_pb__c,-122.4408905

lower_level__c,Bedroom(s),Family Room,Full Bath(s),Garage,Retreat

mls_id__c,424058405

master_bathroom_features__c,Tub w/Shower Over;Tub;Low-Flow Toilet(s);Low-Flow Shower(s)

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-08-18

original_price__c,3538000

overall_days_on_market__c,-82044

parking_access__c,Independent

parking_features__c,Attached,Garage Door Opener

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000033NcfMAE

roof__c,Bitumen

room_type__c,Sun Room;Kitchen;Living Room;Baths Other;Dining Room;Family Room;Primary Bathroom;Primary Bedroom;Primary Bedroom 2+

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Security Gate;Carbon Mon Detector;Window Security Bars

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

size__c,2597

pba__state_pb__c,CA

stories__c,2

pba__street_pb__c,Avila

subdist__c,Marina

ffd_name,278 Avila Street, San Francisco, CA, 94123

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full;Window Coverings

pba__yearbuilt_pb__c,1926

pba__postalcode_pb__c,94123

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1725915467

ffd_listing_title,135 Avila Street, San Francisco, CA, 94123

ffd_mls_id,424061382

ffd_salesforce_id,a0EUd0000032stsMAA

num_of_fireplaces__c,1

num_of_rooms__c,7

of_units__c,0

address2__c,135 Avila Street, San Francisco, CA, 94123

pba__address_pb__c,135 Avila Street, San Francisco, CA, 94123

agent_only_remarks__c,Please call/text Ron at 415-279-4579 with questions or to request a showing. Video and more at www.135Avila.com

appliances__c,Dishwasher;Microwave;Disposal;Free Standing Gas Range;Free Standing Refrigerator;Wine Refrigerator;Ice Maker;Built-In Refrigerator

architectural_style__c,Traditional;Bungalow

bath_features__c,Tub w/Shower Over;Tile;Quartz;Window;Stone

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1925

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2024-09-06T15:47:26.000+0000

days_on_market__c,3

dom__c,3

ffd_description_pb,Perfectly located on picturesque Avila St, this beautifully remodeled 3 bed +sunroom, 2.5 bath home offers refined living just steps to the cafes, shops and restaurants on Chestnut St & the natural beauty of the Marina Green, Crissy Field & The Presidio. A gracious entry leads up to the elegant living room featuring built-in shelving, gas fireplace, custom window treatments & recessed lighting. The gorgeous eat-in kitchen & large formal dining room boast designer finishes, breakfast nook, professional-grade appliances (including wine fridge), plentiful custom cabinetry & abundant natural light. The adjoining patio is perfect for BBQ'ing & outdoor relaxation. 2 spacious bedrooms, a bright sunroom (ideal for office or nursery) w/Juliet balcony overlooking the tree-canopied garden, a luxurious full bathroom, a chic half-bath & additional storage complete this level. A sky-lit rear stairway leads down to the grand-scale primary suite (w/en-suite spa-like bath & large walk-in custom closet) & sitting room/office opening through French doors to the verdant garden -- an oasis for relaxing, al-fresco dining & entertaining. The lower level is completed by a laundry area, 2 closets & 2-car garage w/storage. Beautiful wood floors, air conditioning, skylights, dual-pane windows & more...!

district__c,SF District 7

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

fireplace_features__c,Living Room;Gas Piped

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

has_3d_tour__c,1

pba__heatingtype_pb__c,Central;Gas

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

ffd_lastmodifieddate,2024-09-09T20:48:11.000+0000

pba__latitude_pb__c,37.8017502

pba__latitude_property__c,37.8017502

laundry_features__c,Laundry Closet;Ground Floor;Washer Included;Dryer Included

listed_date__c,2024-08-12

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Ronald

pba__listing_agent_lastname__c,Sebahar

listing_agent_mls_id__c,803012

ffd_listingagentname,Ronald Sebahar

listing_agent_number__c,803012

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

pba__listingtype__c,Sale

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

pba__longitude_pb__c,-122.4408506

lower_level__c,Garage,Primary Bedroom,Retreat,Street Entrance

mls_id__c,424061382

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

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

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-09-06

open_house_end__c,2024-09-10T12:00:00.000+0000

open_house_start__c,2024-09-10T10:00:00.000+0000

original_price__c,4300000

overall_days_on_market__c,-82063

parking_access__c,Tandem

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

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000032stsMAA

road_surface_type__c,Paved

room_type__c,Storage;Office;Sun Room;Kitchen;Living Room;Dining 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,2606

size__c,2606

pba__state_pb__c,CA

stories__c,2

pba__street_pb__c,Avila

subdist__c,Marina

ffd_name,135 Avila Street, San Francisco, CA, 94123

website_property_type__c,Single Family Home

window_features__c,Dual Pane Full

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

_yoast_indexnow_last_ping,1725929805

ffd_listing_title,324 Avila Street, San Francisco, CA, 94123

ffd_mls_id,424059041

ffd_salesforce_id,a0EUd0000032lFrMAI

num_of_fireplaces__c,2

num_of_rooms__c,0

of_units__c,0

address2__c,324 Avila Street, San Francisco, CA, 94123

pba__address_pb__c,324 Avila Street, San Francisco, CA, 94123

agent_only_remarks__c,For more information and showing requests, please contact Jeffrey Stephenson at 415-577-2580, [email protected]

pba__fullbathrooms_pb__c,4

pba__bedrooms_pb__c,4

year_build_text__c,0

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Tim A Brown

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-09-06T10:49:37.000+0000

days_on_market__c,3

dom__c,3

ffd_description_pb,Spacious single-family home in north-side San Francisco's coveted Marina neighborhood. Three levels include a main floor with living room w/ fireplace, formal dining room, and a family/great room off the kitchen with garden access. A full bath adds additional convenience here. The upper floor is the perfect luxury retreat featuring a primary bedroom with spacious walk-in closet. A full bath and an oversize sunroom/bedroom is also found here. At ground level, two bedrooms are complete with en-suite baths. A spacious den, laundry room, and access to the yard and garage round out the floor. SolarCity panels located on the roof help lower your electricity expenses. This wonderful residence is near the Marina Green, St. Francis Yacht Club, Crissy Field, Fort Mason and the plentiful shops, restaurants, and cafes of Chestnut Street. Welcome home to 324 Avila!

district__c,SF District 7

entry_level__c,0

external_listing__c,1

fireplace_features__c,Living Room;Family Room

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-09-10T00:47:23.000+0000

pba__latitude_pb__c,37.8043511

pba__latitude_property__c,37.8043511

laundry_features__c,Laundry Closet;Ground Floor;Washer Included;Dryer Included

listed_date__c,2024-09-05

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jeffrey

pba__listing_agent_lastname__c,Stephenson

listing_agent_mls_id__c,808910

ffd_listingagentname,Jeffrey A Stephenson

listing_agent_number__c,1038477

listing_co_agent_mls_id__c,197834

listing_co_agent_number__c,197834

listing_co_office_mls_id__c,KWADVSF

listing_co_office_name__c,KW Advisors

listing_co_office_number__c,28861

listing_office_mls_id__c,KWADVSF

listing_office_name__c,KW Advisors

listing_office_number__c,28861

pba__listingprice_pb__c,2495000

pba__listingtype__c,Sale

pba__listing_website__c,https://324avila.com

pba__longitude_pb__c,-122.4409188

mls_id__c,424059041

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-09-06

open_house_end__c,2024-09-10T12:00:00.000+0000

open_house_start__c,2024-09-10T10:00:00.000+0000

original_price__c,2495000

overall_days_on_market__c,-82063

parking_access__c,Tandem

parking_features__c,Covered,Uncovered Parking Space

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd0000032lFrMAI

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

size__c,3145

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Avila

subdist__c,Marina

ffd_name,324 Avila Street, San Francisco, CA, 94123

website_property_type__c,Single Family Home

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