119 Melrose Avenue, San Francisco, CA, 94127 - Property Description

_yoast_indexnow_last_ping,1728730389

ffd_listing_title,183 Randall Street, San Francisco, CA, 94131

ffd_mls_id,424057386

ffd_salesforce_id,a0EUd000003L1VdMAK

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,0

address2__c,183 Randall Street, San Francisco, CA, 94131

pba__address_pb__c,183 Randall Street, San Francisco, CA, 94131

agent_only_remarks__c,Please call Charlene for more information and showings. 415-608-8585. Bonus space is 180 sq ft and in included in the 1280 sq ft.

appliances__c,Dishwasher;Built-In Gas Range

architectural_style__c,Victorian

bath_features__c,Marble;Tile

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-10-12T00:50:00.000+0000

days_on_market__c,57

dom__c,48

ffd_description_pb,Located in highly desirable Fairmont Heights, this picturesque peaked-roof Victorian showcases Downtown and Bay Bridge views! Beautiful original-period detailing combined with tasteful renovations create the perfect balance of modern updates and classic SF charm. Upon walking in the front door you'll be greeted by the quality craftsmanship of oak hardwood floors and intricate moldings. Glass french doors open to the light-filled living room featuring a bay window with views, an elegant marble faced fireplace and built-in shelves. The primary bedroom opens into a newly renovated ensuite half bathroom, and the second spacious bedroom offers views of the downtown SF skyline. The newly renovated kitchen features quartz countertops, top of the line cabinetry, and plentiful storage space. An additional fully renovated bathroom completes the main floor. The upper level undeveloped attic space has excellent expansion potential, panoramic views & a spacious deck. Enjoy convenient internal access to the downstairs bonus area (180 SF), laundry, storage area and garage. 183 Randall has a Walkscore of 93 and is perfectly situated between 24th St., Cortland Ave and Glen Park Village, so you'll get to enjoy easy accessibility to the coveted shops and restaurants of all 3 neighborhoods!

district__c,SF District 5

driveway_sidewalks__c,Paved Sidewalk

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

pba__floortype_pb__c,Marble;Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2024-10-12T10:48:03.000+0000

pba__latitude_pb__c,37.7395239

pba__latitude_property__c,37.7395239

laundry_features__c,In Garage;In Basement;Washer Included;Dryer Included

listed_date__c,2024-08-15

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Charlene

pba__listing_agent_lastname__c,Attard

listing_agent_mls_id__c,324325

ffd_listingagentname,Charlene A Attard

listing_agent_number__c,324325

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP90

listing_office_name__c,Compass

listing_office_number__c,29048

pba__listingprice_pb__c,1499000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4274352

lower_level__c,Full Bath(s),Garage

mls_id__c,424057386

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

master_bathroom_features__c,Tile;Marble

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-08-16

open_house_end__c,2024-10-12T16:00:00.000+0000

open_house_start__c,2024-10-12T14:00:00.000+0000

original_price__c,1749000

overall_days_on_market__c,-82042

parking_access__c,Tandem

parking_features__c,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,1171.09

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000003L1VdMAK

road_surface_type__c,Asphalt

roof__c,Shingle

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

size__c,1280

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Randall

subdist__c,Glen Park

ffd_name,183 Randall Street, San Francisco, CA, 94131

view__c,City;Bay;Downtown;Bay Bridge;San Francisco;Hills

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1909

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1728816770

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

ffd_mls_id,424069638

ffd_salesforce_id,a0EUd000003KQz7MAG

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,0

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

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

agent_only_remarks__c,Showings Sat, 10/12: 2-4PM, Sun, 10/13: 12-2:30PM, Tues, 10/15: 12-2PM, Thur, 10/17: 5:30-6:30PM. Please email Gabriella: [email protected] and Frank: [email protected] for showings & questions. Multiple sq ft ranging from 3090 to 3310. Neither seller, broker, nor agent guarantee square footage. Interested parties are advised to do their own due diligence.

appliances__c,Dishwasher;Microwave;Disposal;Wine Refrigerator

architectural_style__c,Modern/High Tech

bath_features__c,Dual Flush Toilet

pba__fullbathrooms_pb__c,5

pba__bedrooms_pb__c,5

year_build_text__c,1923

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Frank A Castaldini

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-10-11T10:48:42.000+0000

days_on_market__c,2

dom__c,2

ffd_description_pb,This newly completed modern luxury residence in the heart of SF, offers 5-bd/5.5ba, practical layout & high-end finishes throughout. You'll be greeted by a foyer looking into a panoramic city, mountain & bay view. A warm living rm w/fireplace & flows to the dining & kitchen area. The chief's kitchen equipped w/Miele appliances, custom Shinoki cabinets & Cesar stone counter/wall slabs. Indoor/outdoor living from kitchen & dining, elevated w/a large deck w/breathtaking panoramic views. Top flr offers 3 bd/2 ba, w/a luxurious master bedrm w/stunning views, spa like bathrm & walk-in-closet. The ground flr is designed for versatility, a family/great rm w/built-in projector screen, custom pantry, laundry rm & storage space. Lush private backyard w/BBQ area, outdoor cooking space & storage shed. Also offers an extra full bath & en-suite flexible space perfect for an office, gym, or guest suite. Centrally located, providing easy access to public transportation: BART, Muni, Popular dining, shopping & rec destinations: SF public library, Upper Noe Rec Ctr, Glen Canyon Trail, Glen Park Rec Ctr, Coffee shops, Tech bus pick-up & impressive 98 walk score. Modern luxury living w/Sonos sounds, Ring doorbell & Smart home ctl. Don't miss the opportunity to make this modern masterpiece yours!

district__c,SF District 5

entry_level__c,0

external_listing__c,1

fencing__c,Back Yard

fireplace_features__c,Living Room

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Central

interior_features__c,Skylight(s);Wet Bar

ffd_lastmodifieddate,2024-10-13T10:47:30.000+0000

pba__latitude_pb__c,37.7365569

pba__latitude_property__c,37.7365569

laundry_features__c,Washer/Dryer Stacked Included;Cabinets

listed_date__c,2024-09-29

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Gabriella

pba__listing_agent_lastname__c,Ghai

listing_agent_mls_id__c,807068

ffd_listingagentname,Gabriella Ghai

listing_agent_number__c,166018154

listing_co_agent_mls_id__c,805355

listing_co_agent_number__c,166015256

listing_co_office_mls_id__c,COMP

listing_co_office_name__c,Compass

listing_co_office_number__c,26293

listing_office_mls_id__c,COMP12

listing_office_name__c,Compass

listing_office_number__c,28739

pba__listingprice_pb__c,3998000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4298737

lower_level__c,Bedroom(s),Family Room,Garage

mls_id__c,424069638

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

master_bathroom_features__c,Double Sinks;Walk-In Closet;Dual Flush Toilet

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-10-11

open_house_end__c,2024-10-13T14:30:00.000+0000

open_house_start__c,2024-10-13T12:00:00.000+0000

original_price__c,3998000

overall_days_on_market__c,-82098

parking_access__c,Independent

parking_features__c,Attached

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

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000003KQz7MAG

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

size__c,3090

pba__state_pb__c,CA

stories__c,3

pba__street_pb__c,Laidley

subdist__c,Glen Park

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

view__c,City;Panoramic;City Lights;Bay;Water;Mountains

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1923

pba__postalcode_pb__c,94131

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1728557818

ffd_listing_title,301 Arlington Street, San Francisco, CA, 94131

ffd_mls_id,424069787

ffd_salesforce_id,a0EUd000003JsvpMAC

num_of_fireplaces__c,1

num_of_rooms__c,5

of_units__c,2

address2__c,301 Arlington Street, San Francisco, CA, 94131

pba__address_pb__c,301 Arlington Street, San Francisco, CA, 94131

agent_only_remarks__c,Has Supra, private showings only, please call Terry Wright at 415.516.8325 or [email protected]

appliances__c,Free Standing Refrigerator;Gas Cook Top

architectural_style__c,Victorian

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,1910

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Terry Wright

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-10-10T02:48:11.000+0000

days_on_market__c,3

dom__c,3

ffd_description_pb,Welcome to this charming two-bedroom Victorian condo in a two-unit building with lovely period detailing! This full flat unit is situated on a corner lot and has wonderful light throughout. In the front of the unit is living room with a decorative fireplace which is adjacent to the formal dining room, which could easily be used as a home office or additional bedroom. In addition, there are two bedrooms which have lots of natural light, a kitchen, bathroom and a rear laundry room. There are hardwood floors, high ceilings and period detailing throughout plus nice views from the rear of the unit. Downstairs is a very large, deeded storage area. Super Glen Park location with great freeway access and within walking distance to Bart and Glen Park Village! This wonderful unit is a must see and a terrific value!

district__c,SF District 5

entry_level__c,0

external_listing__c,1

fireplace_features__c,Living Room;Decorative Only

pba__floortype_pb__c,Wood

hoa_fee_includes__c,Homeowners Insurance,Trash,Water

pba__hoafees__c,302

pba__hoafrequency_pb__c,Monthly

hoa_name__c,301-303 Arlington HOA

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2024-10-10T10:49:27.000+0000

pba__latitude_pb__c,37.7365291

pba__latitude_property__c,37.7365291

laundry_features__c,Inside Room;Washer Included;Dryer Included

listed_date__c,2024-10-07

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Christopher

pba__listing_agent_lastname__c,Stafford

listing_agent_mls_id__c,376399

ffd_listingagentname,Christopher S Stafford

listing_agent_number__c,376399

listing_co_agent_mls_id__c,392353

listing_co_agent_number__c,392353

listing_co_office_mls_id__c,COMP90

listing_co_office_name__c,Compass

listing_co_office_number__c,29048

listing_office_mls_id__c,COMP90

listing_office_name__c,Compass

listing_office_number__c,29048

pba__listingprice_pb__c,899000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.427182

mls_id__c,424069787

master_property__c,a0OUd00000D68bNMAR

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,0

on_market_date__c,2024-10-07

open_house_end__c,2024-10-12T15:00:00.000+0000

open_house_start__c,2024-10-12T13:00:00.000+0000

original_price__c,899000

overall_days_on_market__c,-82094

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

pba__propertytype__c,Condominium

ListingId,a0EUd000003JsvpMAC

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

size__c,999

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Arlington

subdist__c,Glen Park

ffd_name,301 Arlington Street, San Francisco, CA, 94131

website_property_type__c,Condominium

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

_yoast_indexnow_last_ping,1728528974

ffd_listing_title,60 Hiliritas Avenue, San Francisco, CA, 94131

ffd_mls_id,424069713

ffd_salesforce_id,a0EUd000003JkLZMA0

num_of_fireplaces__c,1

num_of_rooms__c,10

of_units__c,0

address2__c,60 Hiliritas Avenue, San Francisco, CA, 94131

pba__address_pb__c,60 Hiliritas Avenue, San Francisco, CA, 94131

agent_only_remarks__c,Trust Sale, owner passed away in April 2024,of natural causes,not at the property. Allow 48 hours for offer response. Offers to be on SFAR Purchase Agreement. Trustee will not consider offers from unrepresented buyers. Buyer to verify square footage to their satisfaction. For showings and disclosures please call/text Ellen @415-517-1402, or [email protected]

appliances__c,Dishwasher;Gas Water Heater;Hood Over Range;ENERGY STAR Qualified Appliances;Free Standing Refrigerator;Double Oven;Plumbed For Ice Maker;Built-In Electric Oven

architectural_style__c,Contemporary;Mid-Century

bath_features__c,Tub w/Shower Over;Shower Stall(s);Tub;Low-Flow Toilet(s);Dual Flush Toilet;Skylight/Solar Tube;Low-Flow Shower(s);Quartz;Window;Stone

pba__fullbathrooms_pb__c,4

pba__bedrooms_pb__c,5

year_build_text__c,1979

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2024-10-09T20:49:39.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Glen Park Luxury: Breathtaking Views from a Modern Haven. This 5 Bed/5 Bath, 3,018 sq ft, 4 Level SFH has so much flexibility. The top floor houses 4 bedrooms with an additional bedroom on the entry level.Discover this exceptional Glen Park home, masterfully updated to blend modern luxury with inviting comfort. Enjoy breathtaking San Francisco vistas from multiple vantage points in this thoughtfully designed residence. Key Features: West-facing decks on each floor for optimal sunlight. Gourmet kitchen with stainless steel appliances, spacious island, and butler's pantry. Luxurious primary suite. Versatile entertainment space with 11-ft ceilings, kitchenette, and full bath. Comprehensive renovation with bespoke details and premium finishes. Prime Location: Walking distance to 66.6-acre Glen Canyon Park (hiking trails, recreation center). Convenient to Glen Park BART, Muni, and easy freeway access. Vibrant neighborhood with local boutiques, cafes, and restaurants. This urban sanctuary offers the perfect balance of city convenience and world class natural surroundings. Enjoy San Francisco's famous sunsets from your private decks in this true Glen Park gem. Contact us to experience the unparalleled charm and sophistication of this masterpiece. Showings by appt.

district__c,SF District 5

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk,Sidewalk/Curb/Gutter

electric__c,220 Volts,220 Volts in Kitchen,220 Volts in Laundry

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

fencing__c,Back Yard;Wood

fireplace_features__c,Living Room;Brick;Gas Log;Raised Hearth

pba__floortype_pb__c,Tile;Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Central;Natural Gas;Fireplace Insert

height_limit__c,Unknown

interior_features__c,Skylight(s)

ffd_lastmodifieddate,2024-10-10T02:47:59.000+0000

pba__latitude_pb__c,37.7375813

pba__latitude_property__c,37.7375813

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included;Upper Floor

listed_date__c,2024-02-01

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Barbara

pba__listing_agent_lastname__c,Jones

listing_agent_mls_id__c,814531

ffd_listingagentname,Ellen Jones

listing_agent_number__c,1066731

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,LKIN

listing_office_name__c,King Realty Group

listing_office_number__c,64197

pba__listingprice_pb__c,3299000

pba__listingtype__c,Sale

pba__listing_website__c,http://www.60hiliritas.com

pba__longitude_pb__c,-122.4377821

lower_level__c,Family Room,Full Bath(s)

mls_id__c,424069713

main_level__c,Full Bath(s);Bedroom(s);Garage;Street Entrance

master_bathroom_features__c,Shower Stall(s);Low-Flow Toilet(s);Quartz;Tile;Walk-In Closet;Marble;Low-Flow Shower(s);Skylight/Solar Tube

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2024-10-09

open_house_end__c,2024-10-12T13:00:00.000+0000

open_house_start__c,2024-10-12T11:00:00.000+0000

original_price__c,3299000

overall_days_on_market__c,-82096

parking_access__c,Independent

parking_features__c,Attached,Garage Door Opener,Garage Facing Front,Interior Access,Side-by-Side,Uncovered Parking Spaces 2+

parking_type__c,On Site (Single Family Only)

patio_and_porch_features__c,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,1093.11

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000003JkLZMA0

road_surface_type__c,Asphalt,Paved

roof__c,Tar/Gravel

room_type__c,Office;Bonus Room;Kitchen;Living Room;Dining Room;Family Room;Primary Bathroom;Primary Bedroom 2+

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Fire Extinguisher;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,3018

size__c,3018

pba__state_pb__c,CA

stories__c,4

pba__street_pb__c,Hiliritas

subdist__c,Glen Park

ffd_name,60 Hiliritas Avenue, San Francisco, CA, 94131

view__c,Park;Panoramic;City Lights;Canyon

website_property_type__c,Single Family Home

window_features__c,Dual Pane Partial;Caulked/Sealed

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