458 Arlington Street, San Francisco, CA, 94131 - Property Description

_yoast_indexnow_last_ping,1713869968

ffd_listing_title,17 Miguel Street, San Francisco, CA, 94131

ffd_mls_id,424020800

ffd_salesforce_id,a0EUd000001ngOxMAI

num_of_fireplaces__c,1

num_of_rooms__c,7

of_units__c,0

address2__c,17 Miguel Street, San Francisco, CA, 94131

pba__address_pb__c,17 Miguel Street, San Francisco, CA, 94131

agent_only_remarks__c,Hidden gem, garages only at street level, detached home and gardens below. CC&R's provide for a great deal of autonomy for each townhome, with no monthly dues, minimal shared expenses. Tour 4/23 12-2pm, Open 4/27-28 1-4pm. Text 415-310-5933 or email [email protected] to show or to request disclosure packet.

appliances__c,Dishwasher;Microwave;Disposal;Electric Cook Top;Free Standing Refrigerator;Built-In Electric Oven

architectural_style__c,Modern/High Tech

bath_features__c,Tub w/Shower Over

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,1978

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-22T10:47:05.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,This contemporary and spacious 3-level home has 2BR/2BA + Den & Family Room and is set back from street level, surrounded by lush private gardens with sweeping views from all rooms. Truly unique in its setting and design. 17 Miguel is one of two detached townhomes custom built in 1978 on the same lot and subsequently subdivided so that each home is substantially independent. An entry garden leads to the main level front door opening into a great room with double-story ceilings. Green house bay windows capture a wide panorama of downtown and the Bay Bridge. Finishes here include hardwood floors, insulated windows, a central wood burning fireplace and built-ins. There is an adjacent dining alcove and modern galley kitchen overlooking the garden entrance. A full bedroom and bath complete this level. Decks off the living room and secondary bedroom. Upstairs, the loft-like den is open to the living room below, with breathtaking picture window views and a sunny private deck. The light and bright primary suite on this level also enjoys stunning views and has its own private deck plus walk-in closet. A large downstairs family room has washer/dryer hookups and draft architectural plans for further development into a separate guest suite. Lovely serene urban retreat in a central location.

district__c,SF District 5

entry_level__c,0

external_listing__c,1

fireplace_features__c,Living Room;Wood Burning

pba__floortype_pb__c,Carpet;Tile;Wood

hoa_fee_includes__c,See Remarks

pba__hoafees__c,0

hoa_name__c,17-19 Miguel Street HOA

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central;Gas

interior_features__c,Skylight(s);Cathedral Ceiling

ffd_lastmodifieddate,2024-04-23T10:47:06.000+0000

pba__latitude_pb__c,37.739441

pba__latitude_property__c,37.739441

laundry_features__c,Hookups Only;Ground Floor

listed_date__c,2024-04-01

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Dona

pba__listing_agent_lastname__c,Crowder

listing_agent_mls_id__c,039695

ffd_listingagentname,Dona Crowder

listing_agent_number__c,39695

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,CBLUXURY

listing_office_name__c,Coldwell Banker Realty

listing_office_number__c,2128

pba__listingprice_pb__c,1775000

pba__listingtype__c,Sale

pba__listing_website__c,http://www.17miguel.com

pba__longitude_pb__c,-122.430543

lower_level__c,Family Room

mls_id__c,424020800

main_level__c,Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance

master_bathroom_features__c,Tub w/Shower Over

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-22

open_house_end__c,2024-04-23T14:00:00.000+0000

open_house_start__c,2024-04-23T12:00:00.000+0000

original_price__c,1775000

overall_days_on_market__c,-81926

parking_access__c,Independent

parking_features__c,Detached,Garage Door Opener

parking_type__c,On Site (Single Family Only);On Site - Mapped (Condo Only)

patio_and_porch_features__c,Uncovered 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,860.81

pba__propertytype__c,Townhouse

ListingId,a0EUd000001ngOxMAI

room_type__c,Den;Kitchen;Living Room;Dining Room;Family Room;Primary Bathroom;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

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

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

size__c,2062

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,Miguel

subdist__c,Glen Park

ffd_name,17 Miguel Street, San Francisco, CA, 94131

view__c,Panoramic;Garden/Greenbelt;Bay;Downtown;Bay Bridge;Mt Diablo

website_property_type__c,Townhouse

window_features__c,Dual Pane Full;Bay Window(s)

pba__yearbuilt_pb__c,1978

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713697095

ffd_listing_title,1840 Church 1842 Street, San Francisco, CA, 94131

ffd_mls_id,424025677

ffd_salesforce_id,a0EUd000001nX78MAE

num_of_fireplaces__c,2

num_of_rooms__c,10

of_units__c,0

address2__c,1840 Church 1842 Street, San Francisco, CA, 94131

pba__address_pb__c,1840 Church 1842 Street, San Francisco, CA, 94131

agent_only_remarks__c,VACANT 2 Noe Valley Units - 1031 Exchange - Sale subject to Seller identifying replacement property. Disclosures are coming soon, and buyers may investigate to their satisfaction. Please call or text Alex to schedule an appointment 415-505-7579.

appliances__c,Gas Water Heater;Free Standing Gas Oven;Gas Plumbed

architectural_style__c,Contemporary

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

pba__fullbathrooms_pb__c,4

pba__bedrooms_pb__c,0

year_build_text__c,1979

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-20T16:46:13.000+0000

days_on_market__c,2

dom__c,2

ffd_description_pb,Spacious Church Street duplex awaits your vision and TLC in Upper Noe Valley. Family-owned for 50 years, now looking for a new owner who needs a large space for hobbies (cars/motorcycles) or an Investor, or even separate individuals with a goal to partner as TIC ownership. Property has 2 identical units with 2 bedrooms &1.5 baths each. Both feature in-unit laundry rooms, formal living rooms w/ fireplaces, formal dining rooms, large kitchens and 1-car parking in garage. The front driveway can accommodate 2 additional cars. Lower unit includes a bonus non-conforming space with an efficiency kitchen & bath that can be used as a private office or gym. Top flat boasts views, and access to a rooftop deck and has an additional Junior apartment above, perfect for guests or an Au pair/Nanny. The rear yard can be accessed via the garage. Proximity to Glen Park and the Church & 30th Shops or the Upper Noe Valley Recreation Center.

district__c,SF District 5

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

fireplace_features__c,Living Room;Wood Burning

pba__floortype_pb__c,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-04-21T10:46:33.000+0000

pba__latitude_pb__c,37.741048

pba__latitude_property__c,37.741048

laundry_features__c,Hookups Only;Inside Area

listed_date__c,2024-04-19

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Alex

pba__listing_agent_lastname__c,Maltez

listing_agent_mls_id__c,980113

ffd_listingagentname,Alex Maltez

listing_agent_number__c,980113

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,BRES02

listing_office_name__c,Bay Area Real Estate Services

listing_office_number__c,27779

pba__listingprice_pb__c,2980850

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.42705

lower_level__c,Loft

mls_id__c,424025677

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,4

on_market_date__c,2024-04-19

open_house_end__c,2024-04-21T16:00:00.000+0000

open_house_start__c,2024-04-21T13:00:00.000+0000

original_price__c,2980850

overall_days_on_market__c,-81923

parking_access__c,Side by Side

parking_features__c,Assigned,Garage Door Opener,Interior Access,Side-by-Side

parking_type__c,Other

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

pba__propertytype__c,Halfplex

ListingId,a0EUd000001nX78MAE

road_surface_type__c,Asphalt

roof__c,Flat

room_type__c,Kitchen;Dining Room;Primary Bathroom

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

size__c,2640

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,Church

subdist__c,Glen Park

ffd_name,1840 Church 1842 Street, San Francisco, CA, 94131

view__c,City;Hills

website_property_type__c,Halfplex

pba__yearbuilt_pb__c,1979

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713909400

ffd_listing_title,186 Lippard Avenue, San Francisco, CA, 94131

ffd_mls_id,424022619

ffd_salesforce_id,a0EUd000001mYDRMA2

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,0

address2__c,186 Lippard Avenue, San Francisco, CA, 94131

pba__address_pb__c,186 Lippard Avenue, San Francisco, CA, 94131

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,1910

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-19T10:49:46.000+0000

days_on_market__c,5

dom__c,5

ffd_description_pb,Delightful two-bedroom Victorian home in A+ Glen Park location. Rich, warm wood floors & period details throughout. Light-filled living room w/ crown molding & bay windows. Beautiful family room/den/home office w/ cute bar sink connects to kitchen. Bright kitchen w/ stainless appliances and quartz counter tops. Generous dining space w/ beautiful, original built-in hutch - great for entertaining! Sumptuous principal bedroom w/ luxe, skylit ensuite bath and French doors opening to the lush garden and hot tub. Flexible second BDR with built in shelving. Laundry room & second full tiled bath complete the home. Stunning garden w/ succulents, lemon tree & mature plantings. Stone patio for al fresco dining. Large basement & attic space - great for all storage needs. Architectural plans for second story addition available. Ample street parking. Nestled in a walker's paradise, this home offers easy access to BART (4 mins), tech shuttles (Google, Genentech, Apple, etc.) (4 mins), Glen Park Library, playgrounds, tennis courts, Canyon Market, Gialina, La Corneta, and more! With proximity to Noe, Bernal, downtown, SFO, 280/101 freeways, and various MUNI lines, this beautiful home with a perfect layout and a charming backyard is will make you swoon.

district__c,SF District 5

entry_level__c,0

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-04-23T21:46:49.000+0000

pba__latitude_pb__c,37.733045

pba__latitude_property__c,37.733045

listed_date__c,2024-03-18

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Jessica

pba__listing_agent_lastname__c,Branson

listing_agent_mls_id__c,805610

ffd_listingagentname,Jessica Branson

listing_agent_number__c,166015601

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP41

listing_office_name__c,Compass

listing_office_number__c,27887

pba__listingprice_pb__c,1395000

pba__listingtype__c,Sale

pba__listing_website__c,http://www.GlenParkDream.com

pba__longitude_pb__c,-122.436368

mls_id__c,424022619

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,0

on_market_date__c,2024-04-18

open_house_end__c,2024-04-23T14:00:00.000+0000

open_house_start__c,2024-04-23T12:00:00.000+0000

original_price__c,1395000

overall_days_on_market__c,-81922

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.82

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001mYDRMA2

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

size__c,1090

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Lippard

subdist__c,Glen Park

ffd_name,186 Lippard Avenue, San Francisco, CA, 94131

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1910

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1713650163

ffd_listing_title,161 Arbor Street, San Francisco, CA, 94131

ffd_mls_id,424023216

ffd_salesforce_id,a0EUd000001iXr3MAE

num_of_fireplaces__c,1

num_of_rooms__c,5

of_units__c,0

address2__c,161 Arbor Street, San Francisco, CA, 94131

pba__address_pb__c,161 Arbor Street, San Francisco, CA, 94131

agent_only_remarks__c,Offer date: April 24th 2024 by 3PM. Contact Brandon Chen for showing instructions at [email protected] or 415-971-1099. The buyers are advised to test the vehicle parking and verify the square footage of the property prior to writing an offer. The disclosures and inspections reports are available upon request. Preferred escrow with First American Title - Silvia Barragan.

appliances__c,Dishwasher;Gas Water Heater;Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator

architectural_style__c,Contemporary

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

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1937

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-12T00:47:11.000+0000

days_on_market__c,9

dom__c,9

ffd_description_pb,One of Glen Park's finest starter home featuring fantastic south facing city view and multi-level decks of outdoor space. The stunning property was extensively renovated in 2013 offering 3 bedroom and 2.5 baths boasting 1632SF of living space and modern finishes. At the main floor, the gated main entry welcomes you a functional open floor plans with abundance of natural lights, French door access to the outdoor deck and gas fireplace in the living/dining/kitchen area. A guest bedroom, full bath with shower over tub, laundry closet, and access to the one car garage. The chef kitchen has SS appliances, contemporary cabinetry, and marble countertop. The iron railing staircase will lead you to the lower level with the private master suite, guest bedroom/office, and a powder room. Both levels has direct access to the backyard decks and patio. The property offers a low maintenance backyard featuring dripping system. You'll enjoy spending time enjoying the view.

district__c,SF District 5

entry_level__c,0

exterior_features__c,Entry Gate;Fire Pit

external_listing__c,1

fencing__c,Back Yard

fireplace_features__c,Living Room;Gas Starter

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

has_3d_tour__c,1

pba__heatingtype_pb__c,Central;Gas;Fireplace(s)

interior_features__c,Skylight Tube;Skylight(s)

ffd_lastmodifieddate,2024-04-20T21:46:43.000+0000

pba__latitude_pb__c,37.7370491

pba__latitude_property__c,37.7370491

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included

listed_date__c,2024-04-01

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Brandon

pba__listing_agent_lastname__c,Chen

listing_agent_mls_id__c,807882

ffd_listingagentname,Brandon S Chen

listing_agent_number__c,1028110

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

pba__listingtype__c,Sale

pba__listing_website__c,https://my.matterport.com/show/?m=hFHvNDwpJrj

pba__longitude_pb__c,-122.4372618

lower_level__c,Bedroom(s),Primary Bedroom,Partial Bath(s)

mls_id__c,424023216

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

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

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-04-11

open_house_end__c,2024-04-20T16:00:00.000+0000

open_house_start__c,2024-04-20T14:00:00.000+0000

original_price__c,1695000

overall_days_on_market__c,-81915

parking_access__c,Independent

parking_features__c,Attached,Garage Door Opener,Interior Access

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,Uncovered Deck;Covered 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,1038.6

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001iXr3MAE

roof__c,Bitumen

room_type__c,Living Room;Primary Bathroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Security Gate;Carbon Mon Detector;Security System Owned

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

size__c,1632

pba__state_pb__c,CA

stories__c,2

pba__street_pb__c,Arbor

subdist__c,Glen Park

ffd_name,161 Arbor Street, San Francisco, CA, 94131

view__c,City

website_property_type__c,Single Family Home

window_features__c,Window Coverings;Window Screens;Caulked/Sealed

pba__yearbuilt_pb__c,1937

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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