meta_query='key:subdist__c;value:Ingleside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218459' 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, 31 Miramar Avenue, San Francisco, CA, 94112
ffd_mls_id, 421539764
ffd_salesforce_id, a0E1I00000USApTUAX
num_of_fireplaces__c, 3
num_of_rooms__c, 8
of_units__c, 0
address2__c, 31 Miramar Avenue, San Francisco, CA, 94112
pba__address_pb__c, 31 Miramar Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Contact listing agent regarding offers on this spacious and lovely home with many private areas. Please do not use Showing Time. Owner occupied. There is no lockbox. 1). All parties should review information, floor plan, photos and Matterport Tour. www.31Miramar.com 2).Please book 1/2 hour appts https://calendly.com/romeo-13/31-miramar-showings All showings are by appt and within COVID guidelines. Visitors are to bring their own masks and submit a PEAD form and pre-approval or POF within 24 hours of showing. 3). Disclosures are available through io and include a Wellington Termite inspection and an Arch contractors inspection. 4). Buyers and agents should verify square footage, other measurements and room count before writing an offer. 5). Please use 7 pg SFAR PA. 6). Escrow officer is Paula Siegel [email protected] 415-874-4427 Email PEAD form and pre-approval/POF to [email protected] PLEASE NO PRE-EMPTIVE OFFERS. You will be met at the property by listing agent. Laundry room has combination washer/dryer. Please see agent regarding a seller rent back. Seller has the right to accept, counter or reject any and all offers.
appliances__c, Dishwasher;Microwave;Disposal;Tankless Water Heater;Free Standing Gas Range
architectural_style__c, Mediterranean
bath_features__c, Shower Stall(s);Marble;Low-Flow Toilet(s);Low-Flow Shower(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1929
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-05-04
cooling__c, Ceiling Fan(s)
ffd_createddate, 2021-04-23T01:05:30.000+0000
days_on_market__c, 818
dom__c, 14
ffd_description_pb, Located on the first block of Miramar Avenue, this spacious, light-filled home is perched three blocks above Ocean Ave. and its vibrant Ingleside neighborhood. Built in 1929 (Per City records), recent renovations have transformed this home into two-levels of living space w/clean, modern sensibilities. The thoughtful floor plan is flooded w/natural light from the many windows and skylights. Main level: open living/dining area w/dec frplc., bdrm, bath w/Euro fixtures, eat-in kitchen w/a picture window that overlooks the garden. Adjoining the kitchen is the lounge w/gas frplc and access to a deck. Second level: large hall leads to a laundry rm, bdrm/office w/a large closet. Double doors open to the romantic bdrm garden suite, w/gas frplc; bath w/marble and glass, w/geometric tiles, heated flr and a lrg curbless shower; walk-in closet. Sliding doors open to the patio, hot tub and fragrant garden. Huge, one-car garage w/storage, drvwy prkng for 2nd car and a second entry door at this level.
district__c, SF District 3
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Back Yard;Wood
fireplace_features__c, Living Room;Decorative Only;Family Room;Master Bedroom;Gas Log
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Pellet Stove;Radiant Floor;Electric;Gas;Fireplace Insert;MultiUnits
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2022-01-25T15:50:32.000+0000
pba__latitude_pb__c, 37.7187796
pba__latitude_property__c, 37.7187796
laundry_features__c, Other;Ground Floor;Gas Hook-Up;Electric;Cabinets
listed_date__c, 2021-02-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, James Romeo
pba__listing_agent_lastname__c, Holloway
listing_agent_mls_id__c, 215800
ffd_listingagentname, James Romeo Holloway
listing_agent_number__c, 215800
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CGL01
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28273
pba__listingprice_pb__c, 1495000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4584518
lower_level__c, Bedroom(s),Full Bath(s),Garage,Master Bedroom,Street Entrance
mls_id__c, 421539764
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room;Street Entrance
master_bathroom_features__c, Shower Stall(s);Low-Flow Toilet(s);Tile;Marble;Low-Flow Shower(s);Radiant Heat
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-04-22
original_price__c, 1495000
overall_days_on_market__c, 40
parking_access__c, Tandem
parking_features__c, Enclosed,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2021-05-06
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 828.49
pba__propertytype__c, Single Family Residence
id, a0E1I00000USApTUAX
room_type__c, Office;Laundry;Kitchen;Living Room;Dining Room;Family Room;Master Bedroom
sale_date__c, 2021-06-15
sale_price__c, 1710000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 809630
selling_agent_number__c, 1042187
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Better Homes and Gardens Real Estate Thrive
pba__status__c, Closed
pba__totalarea_pb__c, 2064
size__c, 2064
spa__c, 1
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Miramar
subdist__c, Ingleside
ffd_name, 31 Miramar Avenue, San Francisco, CA, 94112
view__c, Garden/Greenbelt;San Francisco;Hills;Sutro Tower
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Bay Window(s)
pba__yearbuilt_pb__c, 1929
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530224256-1.jpg
ListingId, a0E1I00000USApTUAX