meta_query='key:subdist__c;value:Lone Mountain|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='419601' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70653
[post_author] => 4
[post_date] => 2018-11-30 20:30:26
[post_date_gmt] => 2018-11-30 20:30:26
[post_content] => Charming single-family homes on streets that made sense before the University of San Francisco left its footprint on the neighborhood. The most charming circular street you'll ever meet (hello, Ewing Terrace). Discontiguous streets and student life just north of the North Panhandle.
[post_title] => Lone Mountain
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => lone-mountain
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-17 07:57:25
[post_modified_gmt] => 2024-04-17 14:57:25
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70653
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
_yoast_indexnow_last_ping, 1729220345
ffd_listing_title, 283 Parker Avenue, San Francisco, CA, 94118
ffd_mls_id, 424074527
ffd_salesforce_id, a0EUd000003O0gHMAS
num_of_rooms__c, 17
of_units__c, 3
address2__c, 283 Parker Avenue, San Francisco, CA, 94118
pba__address_pb__c, 283 Parker Avenue, San Francisco, CA, 94118
agent_only_remarks__c, Unit A is vacant and can be accessed with Supra after first OH. Do Not disturb tenants Unit B & Unit C. We are requesting for you to show the Unit A FIRST and THEN make an appointment to view the tenant-occupied units with at least 24 hours in advance notice. Pre-listing escrow open with Fidelity National Title. Email [email protected] for OM and Disclosures. Pre-Escrow is opened with Fidelity National Title Company. Email LA w/ offer questions. Offer as it comes. Offers to be submitted with SFAR Purchase Agreement. Pls submit with offer: POF, Pre-Approval Letter if obtaining a loan, & sign off the Disclosures Coversheet. As-Is Sale Condition. Agents and prospective buyers are advised to conduct their own due diligence regarding the square footage of the property. Seller reserves the rights to accept, counter, and reject offers.
appliances__c, Dishwasher;Gas Water Heater;Disposal;Free Standing Gas Oven;Free Standing Refrigerator;Free Standing Electric Range;Varies By Unit
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 8
year_build_text__c, 1988
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Henry H Low
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-10-18T01:50:10.000+0000
days_on_market__c, 0
dom__c, 0
ffd_description_pb, Built in 1988, this well-maintained and updated triplex offers a rare opportunity for investorsno rent control! Located in a prime spot near USF and the Laurel Heights Shopping Center, this property has excellent potential for strong market rents. The largest unit, currently vacant, features 3 bedrooms, 2 bathrooms, a sunroom/office, an updated kitchen and baths, a formal living room with a fireplace, and a dining areaperfect for an owner-occupier or setting a high market rental rate. The second unit includes 3 bedrooms, 2 bathrooms, a formal living room with a fireplace, a dining area, and direct access to a spacious deck. The third unit offers 2 bedrooms, 2 bathrooms, a formal living room with a fireplace, a dining area, and its own deck access. Additional highlights include a private garage, a shared backyard, and coin-operated laundry for extra income. The ground floor also features unwarranted rooms with potential for an ADUbuyers should verify with the SF Building Department. With its unbeatable location near USF, Geary Blvd, shopping, dining, and transportation, 283 Parker is an exceptional investment for anyone looking to maximize returns without rent control limitations.
district__c, SF District 1
exterior_features__c, Fenced Yard
external_listing__c, 1
pba__floortype_pb__c, Carpet;Laminate;Tile
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas
ffd_lastmodifieddate, 2024-10-18T02:49:28.000+0000
pba__latitude_pb__c, 37.7804779
pba__latitude_property__c, 37.7804779
laundry_features__c, Coin Operated
listed_date__c, 2024-09-13
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Rachel
pba__listing_agent_lastname__c, Wong
listing_agent_mls_id__c, 803571
ffd_listingagentname, Rachel F Wong
listing_agent_number__c, 803571
listing_co_agent_mls_id__c, 229265
listing_co_agent_number__c, 229265
listing_co_office_mls_id__c, PRIME
listing_co_office_name__c, Prime Metropolis Prop., Inc.
listing_co_office_number__c, 25594
listing_office_mls_id__c, PRIME
listing_office_name__c, Prime Metropolis Prop., Inc.
listing_office_number__c, 25594
pba__listingprice_pb__c, 2590000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4542977
mls_id__c, 424074527
parkingspaces__c, 2
on_market_date__c, 2024-10-17
open_house_end__c, 2024-10-20T16:00:00.000+0000
open_house_start__c, 2024-10-20T14:00:00.000+0000
original_price__c, 2590000
overall_days_on_market__c, -82104
parking_features__c, Attached,Garage,Garage Door Opener,Tandem Garage
patio_and_porch_features__c, Balcony/Deck;Varies by Unit
pba__pendingdate__c, 1800-01-01
price_per_square_foot__c, 556.99
pba__propertytype__c, Triplex
ListingId, a0EUd000003O0gHMAS
roof__c, Bitumen
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Fire Extinguisher;Carbon Mon Detector;Double Strapped Water Heater
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, 4650
size__c, 4650
pba__state_pb__c, CA
stories__c, 4
pba__street_pb__c, Parker
subdist__c, Lone Mountain
ffd_name, 283 Parker Avenue, San Francisco, CA, 94118
view__c, San Francisco;Golden Gate Bridge;Varies by Unit
website_property_type__c, Triplex
window_features__c, Dual Pane Full;Window Coverings;Window Screens
pba__yearbuilt_pb__c, 1988
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530873879-1.jpg
