meta_query='key:subdist__c;value:Ingleside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='219014' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12158
[post_author] => 4
[post_date] => 2018-10-29 01:19:09
[post_date_gmt] => 2018-10-29 01:19:09
[post_content] => Ingleside is a lot more down-to-earth than some of its swankier neighbors on the north end of town, and it's also a lot more affordable. Homes tend to be modest, some in the same family for generations. Unexpected views of downtown add to the attraction of this more-affordable neighborhood, which also has great public transit options and easy freeway access.
[post_title] => Ingleside
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => ingleside
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 11:47:15
[post_modified_gmt] => 2024-04-09 18:47:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12158
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 7 Miramar Avenue, San Francisco, CA, 94112
ffd_mls_id, 421554248
ffd_salesforce_id, a0E1I00000UTUWcUAP
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 7 Miramar Avenue, San Francisco, CA, 94112
pba__address_pb__c, 7 Miramar Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Darling home in prime Ingleside neighborhood, just a few blocks from trendy Ocean Avenue. No sign on property (intentional). One of the bedrooms used as a bedroom may not be considered a legal bedroom. Buyer to investigate to their satisfaction with the appropriate professionals. The additional bonus room next to the garage was apparently built without the benefit of permits. Visit 7Miramar.com for cinematic video tour, 3D virtual tour and floor plan, or click on the Virtual Media link here on MLS. SHOWINGS: Virtual 24/7 and/or Covid compliant in-person showings by appointment scheduled via Calendly - https://calendly.com/vlshowings/7miramar (or if all booked, then call/text Vivian (415) 717-6308 since appointments are no longer mandatory!). Agent and buyers must electronically sign/send PEAD form prior to any/all showings - email to [email protected]. After sending PEAD, text Vivian (415) 717-6308 for specific lockbox location at the property. Disclosures are available on Disclosures.io now. As-is sale, no warranties expressed or implied. Offer date Thursday 5/27, 2 pm. All offers to be submitted on SFAR purchase contract. Pre-escrow with First American Title, West Portal Avenue - Liz Paglinawan, Escrow # 6562345.
appliances__c, Dishwasher;Microwave;Disposal;Tankless Water Heater;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Traditional
bath_features__c, Shower Stall(s);Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1927
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-05-20T18:46:59.000+0000
days_on_market__c, 790
dom__c, 7
ffd_description_pb, This 3 BR/2 BA designer home blends traditional style w/ contemporary comfort. The kitchen and bathrooms are remodeled, reflecting the latest trends while still remaining classic & timeless. Living room has bay windows, wood-burning fireplace and recessed lighting.Stylish eat-in kitchen features newer stainless steel appliances, quartz countertops, cast-iron sink, cabinet lighting & Grohe fixtures.Upstairs spa bathroom has heated marble floors.Lower level offers third bedroom w/ ensuite modern bathroom. A newly built add'l bonus room is perfect for a home office or fitness studio. Brand-new roof. Newer flooring throughout the entire house. Low maintenance, private backyard w/ new concretepatio and Ipe deck, complete w/ landscape lighting. City views from the rear of the house/backyard. 2 car parking - garage & driveway. Enjoy unparalleled walkability & lifestyle. Just a few blocks to vibrant Ocean Avenue shopping, restaurants and transit corridor! Close proximity to Freeway 280.
district__c, SF District 3
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Fenced
fireplace_features__c, Living Room;Wood Burning;Brick
pba__floortype_pb__c, Marble;Tile;Vinyl;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Radiant Floor;Central;Fireplace(s)
ffd_lastmodifieddate, 2022-01-25T15:53:00.000+0000
pba__latitude_pb__c, 37.7184
pba__latitude_property__c, 37.7184
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2021-04-14
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Vivian
pba__listing_agent_lastname__c, Lee
listing_agent_mls_id__c, 802845
ffd_listingagentname, Vivian Lee
listing_agent_number__c, 802845
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CITYRE
listing_office_name__c, City Real Estate
listing_office_number__c, 27425
pba__listingprice_pb__c, 899000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?brand=0&m=joSjV8xM9PC
pba__longitude_pb__c, -122.458417
lower_level__c, Bedroom(s),Full Bath(s),Garage
mls_id__c, 421554248
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_bathroom_features__c, Tub w/Shower Over;Tile;Marble;Window;Radiant Heat
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-05-20
original_price__c, 899000
overall_days_on_market__c, 147
parking_access__c, Independent
parking_features__c, Attached,Covered,Interior Access,Other
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck;Uncovered Patio;Front Porch
pba__pendingdate__c, 2021-05-27
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1025.45
pba__propertytype__c, Single Family Residence
id, a0E1I00000UTUWcUAP
roof__c, Bitumen
room_type__c, Bonus Room;Sun Room;Attic
sale_date__c, 2021-06-17
sale_price__c, 1410000
security_features__c, Smoke Detector;Video System
selling_agent_mls_id__c, 810769
selling_agent_number__c, 1047912
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Global Living
pba__status__c, Closed
pba__totalarea_pb__c, 1375
size__c, 1375
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Miramar
subdist__c, Ingleside
ffd_name, 7 Miramar Avenue, San Francisco, CA, 94112
view__c, City;City Lights;San Francisco
website_property_type__c, Single Family Home
window_features__c, Bay Window(s);Dual Pane Partial;Window Screens
pba__yearbuilt_pb__c, 1927
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530245972-1.jpg
ListingId, a0E1I00000UTUWcUAP