meta_query='key:subdist__c;value:Midtown Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='345908' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12175
[post_author] => 4
[post_date] => 2018-10-30 00:43:30
[post_date_gmt] => 2018-10-30 00:43:30
[post_content] => Mention Midtown Terrace to many San Franciscans and you’ll be met with a quizzical gaze. Where is it? What is it? It’s a mid-century neighborhood on the west side of Twin Peaks. Think single-family homes, fully detached, with both front and rear yards, lots of green space, and peace and quiet.
[post_title] => Midtown Terrace
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => midtown-terrace
[to_ping] =>
[pinged] =>
[post_modified] => 2023-10-30 17:02:30
[post_modified_gmt] => 2023-10-31 00:02:30
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12175
[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, 1700568780
ffd_listing_title, 630 Panorama Drive, San Francisco, CA, 94131
ffd_mls_id, 423916440
ffd_salesforce_id, a0E8W00000dvwKHUAY
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 630 Panorama Drive, San Francisco, CA, 94131
pba__address_pb__c, 630 Panorama Drive, San Francisco, CA, 94131
agent_only_remarks__c, Thank you for your interest in 630 Panorama. Offers are due on Monday October 30 at 12 Noon. How to submit an offer: In an effort to give your offer the best chance of success we respectfully request that you please submit your offer through Disclosures.io and use a SFAR Purchase Contract that stipulates that buyer's initial deposit will be in escrow within 1 business day of acceptance. Please include and reference in your Purchase Contract the SFAR As Is Addendum, Compass Non-Conformity Advisory and Compass Buyer Insurance Advisory. Escrow has been opened with First American Title Insurance Company, escrow officer Heather Shiffer at 415-645-8011. With your offer, please include the following: If removing contingencies, include SFAR's Contingency Removal Loan Pre-Approval Letter (if applicable) and/or Proof of Funds Buyer's signed Cover Sheet of the Disclosure Package Unless you are including the fully signed disclosures and your AVID with the offer, under "Additional Terms and Conditions" please add that: 1) Disclosure package will be signed by Buyer and returned to listing agent within 24 hours of ratification, and 2) Selling agent to complete and return AVID within 48 hours of ratification.
architectural_style__c, Mid-Century
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1957
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Sharon L Collier
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-10-20T15:47:05.000+0000
days_on_market__c, 32
dom__c, 10
ffd_description_pb, Welcome to this stunning home located in desirable Midtown Terrace. With its spacious layout, modern updates, and serene surroundings, this property offers a perfect blend of comfort and convenience. Step inside and be greeted by the bright and airy living space. The main level features three bedrooms and one and a half baths, providing ample room for relaxation and privacy. The tastefully updated interior boasts hardwood floors, period fireplace and a spacious updated eat in kitchen with loads of storage. Downstairs, you'll find a bonus room with built in window seat overlooking the garden, and an additional bath. This floor offers endless possibilities for use. Whether you envision a home office, a media room, or a guest suite, this versatile space can accommodate your needs. Outside, the property is fully detached, providing a sense of privacy and tranquility. The low maintenance landscaping and lovely carriage lamps enhance the curb appeal. The rear garden has ample space for relaxing, riding your tricycle and offers a delightful space for outdoor entertaining or simply enjoying the California sunshine. Nestled in the oh so central Midtown Terrace neighborhood'', this home offers a suburban feel in the heart of San Francisco.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Carpet;Laminate;Linoleum;Tile;Wood
pba__hoafees__c, 18
pba__hoafrequency_pb__c, Annually
hoa_name__c, Midtown Terrace Home Owners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Wall Furnace;Natural Gas
ffd_lastmodifieddate, 2023-11-21T11:47:46.000+0000
pba__latitude_pb__c, 37.7540349
pba__latitude_property__c, 37.7540349
laundry_features__c, In Garage;Washer Included;Dryer Included;Sink;Chute
listed_date__c, 2023-10-04
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Eric
pba__listing_agent_lastname__c, Weaver
listing_agent_mls_id__c, 383852
ffd_listingagentname, Eric Weaver
listing_agent_number__c, 383852
listing_co_agent_mls_id__c, 317045
listing_co_agent_number__c, 317045
listing_co_office_mls_id__c, COMP7
listing_co_office_name__c, Compass
listing_co_office_number__c, 28751
listing_office_mls_id__c, COMP7
listing_office_name__c, Compass
listing_office_number__c, 28751
pba__listingprice_pb__c, 1350000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.630Panorama.com/mls/118221411
pba__longitude_pb__c, -122.4516986
mls_id__c, 423916440
master_bathroom_features__c, Tub w/Shower Over
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-10-20
original_price__c, 1350000
overall_days_on_market__c, -81741
parking_access__c, Tandem
parking_features__c, Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-10-30
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-11-20T15:50:02.000+0000
price_per_square_foot__c, 981.08
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000dvwKHUAY
sale_date__c, 2023-11-20
sale_price__c, 1400000
selling_agent_mls_id__c, 817963
selling_agent_number__c, 1076775
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Redfin
pba__status__c, Closed
pba__totalarea_pb__c, 1427
size__c, 1427
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Panorama
subdist__c, Midtown Terrace
ffd_name, 630 Panorama Drive, San Francisco, CA, 94131
view__c, City Lights;Garden/Greenbelt;Forest
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1957
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530695037-1.jpg