Home > Certified New Homes > Find Builders and Incentives > New Homes Partners in Rhode Island

Program Indicators in Rhode Island

  • 4,217 ENERGY STAR certified homes built to date
  • 13 ENERGY STAR certified homes built 2014 to date
  • 80 ENERGY STAR certified homes built in 2013
  • 8 ENERGY STAR for Homes Partners

Compare to other states

ENERGY STAR certified homes built in 2013 are the equivalent of:

  • Eliminating emissions from 36 vehicles
  • Saving 148,880 lbs of coal
  • Planting and growing 4,400 coniferous trees for 10 years
  • Saving the environment 381,280 pounds of CO2
Based on national averages

Find Builders in Rhode Island

View All Builders in RI
Map of Rhode Island

Find Builders outside of these Metro Areas

Find Incentives in Rhode Island

Name Partner Since ASC Incentive Description
New England Gas Company
401-272-5040
2010

Find Raters Serving Rhode Island

Name Partner Since Homes Certified
Apr 2013 - Mar 2014*
DESC
Homes Certified
State Total*
Homes Certified
Grand Total*
Environments for Living/Masco Home Services
866-912-7233
Other Areas in Rhode Island
Indoor AirPLUS icon
2002 10,609 0 128,624
Conservation Services Group - New England
508-836-9500
Providence-Warwick
1996 107 4,169 21,728
Systems Building Research Alliance (SBRA)
212-496-0900
Other Areas in Rhode Island
2005 0 0 335

Find Lenders Serving Rhode Island

Name ASC Partner Since Loan Features (Call partner for more info)
Real Estate Mortgage Network, Inc.
770-685-6619
2012 Offers energy improvement mortgages (EIMs) from FHA and VA

* There is a reporting period for submitting ENERGY STAR certified homes data that occurs after the end of each calendar quarter. The "Homes Certified" columns are updated for all partners after the reporting period ends and all data has been approved by EPA.

Providence-New Bedford-Fall River


Debugging Information
ColdFusion Server Enterprise 10,0,13,287689
Template /index.cfm
Time Stamp 23-Jul-14 12:48 PM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 192.168.15.110
Host Name 192.168.15.110


Execution Time

Total Time Avg Time Count Template
186 ms 186 ms 1 /data/cf_code/estar/fbx_fusebox30_cf50.cfm
186 ms 186 ms 1 top level /data/cf_code/estar/index.cfm
114 ms 114 ms 1 /data/cf_code/estar/ia/new_homes/partners/fbx_switch.cfm
113 ms 113 ms 1 /data/cf_code/estar/ia/new_homes/partners/fa_showstateresults.cfm
58 ms 58 ms 1 /data/cf_code/estar/ia/new_homes/partners/qry_showstateresults_partners.cfm
54 ms 54 ms 1 /data/cf_code/estar/ia/fbx_layouts.cfm
25 ms 25 ms 1 /data/cf_code/estar/ia/new_homes/partners/qry_showstateresults_programindicators.cfm
11 ms 11 ms 1 /data/cf_code/estar/ia/new_homes/partners/qry_showstateresults_metroareas.cfm
10 ms 10 ms 1 /data/cf_code/estar/ia/dsp_menu.cfm
4 ms 4 ms 1 /data/cf_code/estar/ia/new_homes/partners/qry_showstateresults_othercities.cfm
4 ms 4 ms 1 /data/cf_code/estar/ia/new_homes/partners/view_showstateresults.cfm
3 ms 3 ms 1 /data/cf_code/estar/ia/act_metatags_set.cfm
3 ms 3 ms 1 /data/cf_code/estar/ia/lay_english_default.cfm
2 ms 2 ms 1 /data/cf_code/estar/Application.cfm
2 ms 2 ms 1 /data/cf_code/estar/fbx_settings.cfm
2 ms 2 ms 1 /data/cf_code/estar/ia/lay_english_standard.cfm
1 ms 1 ms 1 /data/cf_code/estar/OnRequestEnd.cfm
1 ms 1 ms 1 /data/cf_code/estar/fbx_circuits.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/act_js_set.cfm
1 ms 1 ms 2 /data/cf_code/estar/ia/dsp_footer.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/dsp_header.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/fbx_settings.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/new_homes/fbx_settings.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/new_homes/partners/act_getlastfourqtrs.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_cache_init.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_debug_init.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_layoutoption_init.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_message_init.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_specialurlformat_init.cfm
0 ms 0 ms 2 /data/cf_code/estar/fbx_server.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/act_layout_pick.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/act_pagecrumb_set.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/act_pagetitle_set.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_acrobat_link.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_devnotes.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_email_link.cfm
0 ms 0 ms 2 /data/cf_code/estar/ia/dsp_footer_links.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_googletagmanager.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_megamenu.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_photo.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_printable_link.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_sections.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_sitesearch_textbox.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_slogan.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_trail.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/metadata/metadata.wddx
0 ms 0 ms 1 /data/cf_code/estar/ia/new_homes/fbx_layouts.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/new_homes/partners/act_stagingrobots.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/new_homes/partners/dsp_commitments.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/new_homes/partners/fbx_layouts.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/new_homes/partners/fbx_settings.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/new_homes/partners/lay_mid_col.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/new_homes/partners/qry_showstateresults_state.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/new_homes/partners/stateImageMaps/dsp_ri.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/new_homes/partners/udf_buildsortlinks.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/new_homes/partners/val_showstateresults.cfm
0 ms 0 ms 2 /data/cf_code/estar/ia/val_language.cfm
0 ms 0 ms 2 /data/cf_code/estar/ia/val_layout.cfm
0 ms 0 ms 1 /data/cf_code/estar/lockoutapps.cfm
0 ms 0 ms 1 /data/coldfusion10/cfusion/CustomTags/inputfilter.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
189 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

12:48:42.042 - MissingInclude Exception - in /data/cf_code/estar/fbx_fusebox30_cf50.cfm : line 311
	    Could not find the included template fbx_Layouts.cfm.
	    


SQL Queries

qState (Datasource=star_read, Time=0ms, Records=1) in /data/cf_code/estar/ia/new_homes/partners/qry_showstateresults_state.cfm @ 12:48:42.042
SELECT
	s_code,
	state_name
FROM ref_state
WHERE s_code = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = RI

qAreas (Datasource=star_read, Time=9ms, Records=2) in /data/cf_code/estar/ia/new_homes/partners/qry_showstateresults_metroareas.cfm @ 12:48:42.042
SELECT DISTINCT
	rm.msa_id,
	rm.msa_display_name,
	CASE WHEN msa_display_name LIKE '%Various%' THEN
		1
	ELSE
		0
	END AS display_order
FROM
	ref_msa rm,
	xref_msa_location x,
	ref_location_data rl
WHERE
	rl.s_code = ?
	AND rl.ld_id = x.ld_id
	AND x.msa_id = rm.msa_id
ORDER BY
	display_order,
	msa_display_name
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = RI

qOther (Datasource=, Time=2ms, Records=1) in /data/cf_code/estar/ia/new_homes/partners/qry_showstateresults_metroareas.cfm @ 12:48:42.042
SELECT *
FROM qAreas
WHERE display_order = 1
qAllHomesBuilt (Datasource=star_read, Time=2ms, Records=1) in /data/cf_code/estar/ia/new_homes/partners/qry_showstateresults_programindicators.cfm @ 12:48:42.042
SELECT NVL(SUM(ha_quantity_labeled), 0) AS cnt
FROM home_aggregate
WHERE s_code = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = RI

qAllHomesBuiltThisYear (Datasource=star_read, Time=2ms, Records=1) in /data/cf_code/estar/ia/new_homes/partners/qry_showstateresults_programindicators.cfm @ 12:48:42.042
SELECT NVL(SUM(ha_quantity_labeled), 0) AS cnt
FROM home_aggregate
WHERE
	s_code = ?
	AND TO_CHAR(ha_start_date, 'yyyy') >= ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = RI
Parameter #2(CF_SQL_VARCHAR) = 2014

qAllHomesBuiltLastYear (Datasource=star_read, Time=2ms, Records=1) in /data/cf_code/estar/ia/new_homes/partners/qry_showstateresults_programindicators.cfm @ 12:48:42.042
SELECT NVL(SUM(ha_quantity_labeled), 0) AS cnt
FROM home_aggregate
WHERE
	s_code = ?
	AND TO_CHAR(ha_start_date, 'yyyy') = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = RI
Parameter #2(CF_SQL_VARCHAR) = 2013

qAllPartners (Datasource=star_read, Time=17ms, Records=1) in /data/cf_code/estar/ia/new_homes/partners/qry_showstateresults_programindicators.cfm @ 12:48:42.042
SELECT NVL(COUNT(re_id), 0) AS cnt
FROM (
	SELECT DISTINCT re_id
	FROM
		relation re,
		organization o
	WHERE
		re_code = 'PAR'
		AND rel_status_code = 'ACT'
		AND p_code IN ('HOREPS','HVERORG','HBUILDER','HLENDER')
		AND o.s_code = ?
		AND re.o_id = o.o_id
)
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = RI

qIncentives (Datasource=star_read, Time=8ms, Records=1) in /data/cf_code/estar/ia/new_homes/partners/qry_showstateresults_partners.cfm @ 12:48:42.042
SELECT DISTINCT
	h.o_id,
	h.organization_formal_name,
	h.o_web_address,
	h.o_phone1,
	h.partner_since,
	h.a_start_date,
	h.incentive_cat,
	h.incentive_details,
	h.committment AS commitment,
	h.alp_yn
FROM
	homes_locator_data h,
	homes_locator_msa_data hm,
	xref_msa_location xm,
	ref_location_data rl,
	relation re
WHERE
	rl.s_code = ?
	AND rl.s_code = h.s_code
	AND rl.ld_id = xm.ld_id
	AND xm.msa_id = hm.msa_id
	AND hm.hld_id = h.hld_id
	AND (
		h.incentive_cat IS NOT NULL
		OR h.incentive_details IS NOT NULL
	)
	AND re.p_code = ?
	AND h.o_id = re.o_id
ORDER BY
	partner_since ASC,
	organization_formal_name
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = RI
Parameter #2(CF_SQL_VARCHAR) = HOREPS

qRaters (Datasource=star_read, Time=30ms, Records=5) in /data/cf_code/estar/ia/new_homes/partners/qry_showstateresults_partners.cfm @ 12:48:42.042
SELECT *
FROM (
	SELECT
		hd.o_id,
		hd.organization_formal_name,
		o_web_address,
		hd.o_phone1,
		hd.partner_since,
		hd.a_start_date,
		CASE WHEN NVL(homes_labeled_total, 0) > 0 THEN
			TO_CHAR(NVL(homes_labeled_last_4q, 0), '999,999,999')
		WHEN a_start_date IS NOT NULL AND a_start_date >= ? OR hd.a_extension_end_date <= ? OR hd.hd_avg_home <? THEN
			'New Partner'
		ELSE
			'Homes Pending'
		END AS qtrTotal,
		CASE WHEN NVL(homes_labeled_total, 0) > 0 THEN
			TO_CHAR(PKG_HOMES_LOCATOR.Get_state_total(hd.o_id, ?, ?), '999,999,999')
		WHEN a_start_date IS NOT NULL AND a_start_date >= ? OR hd.a_extension_end_date <= ? OR hd.hd_avg_home <? THEN
			'New Partner'
		ELSE
			CASE WHEN NVL(homes_labeled_total, 0) = 0 THEN
				'Homes Pending'
			ELSE
				TO_CHAR(PKG_HOMES_LOCATOR.Get_state_total(hd.o_id, ?, ?), '999,999,999')
			END
		END AS stateTotal,
		CASE WHEN NVL(homes_labeled_total, 0) > 0 THEN
			TO_CHAR(NVL(homes_labeled_total, 0), '999,999,999')
		WHEN a_start_date IS NOT NULL AND a_start_date >= ? OR hd.a_extension_end_date <= ? OR hd.hd_avg_home <? THEN
			'New Partner'
		ELSE
			CASE WHEN NVL(homes_labeled_total, 0) = 0 THEN
				'Homes Pending'
			ELSE
				TO_CHAR(NVL(homes_labeled_total, 0), '999,999,999')
			END
		END AS grandTotal,
		hd.homes_labeled_last_4q,
		PKG_HOMES_LOCATOR.Get_state_total(hd.o_id, ?, ?) AS homes_labeled_state_total,
		hd.homes_labeled_total,
		rm.msa_display_name,
		CASE WHEN rm.msa_display_name <> '(Various)' THEN
			'N'
		ELSE
			'Y'
		END AS has_other_msa_yn,
	    case 
		    when  exists (select o_id from relation r where r.p_code = 'IAPVERIF' AND r.RE_CODE = 'PAR' AND r.REL_STATUS_CODE = 'ACT' and r.o_id = hd.o_id) then 'Y' else 'N'
	    end as iap_yn
	FROM
		homes_locator_data hd,
		homes_service_area hs,
		ref_msa rm
	WHERE
		rm.msa_id IN (
			SELECT DISTINCT(msa_id)
			FROM
				ref_location_data r,
				xref_msa_location x
			WHERE
				r.s_code = ?
				AND r.ld_id = x.ld_id
		)
		AND hd.partner_type = ?
		AND hd.o_id = hs.o_id
		AND hs.msa_id = rm.msa_id
)
ORDER BY
	
	TO_NUMBER(DECODE(qtrTotal, 'Homes Pending', '-1', 'New Partner', '-2', REPLACE(qtrTotal, ','))) DESC,
		
	organization_formal_name,
	
	has_other_msa_yn,
	msa_display_name
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 01-Apr-2013
Parameter #2(CF_SQL_VARCHAR) = 31-Mar-2014
Parameter #3(CF_SQL_NUMERIC) = 5
Parameter #4(CF_SQL_VARCHAR) = HER
Parameter #5(CF_SQL_VARCHAR) = RI
Parameter #6(CF_SQL_VARCHAR) = 01-Apr-2013
Parameter #7(CF_SQL_VARCHAR) = 31-Mar-2014
Parameter #8(CF_SQL_NUMERIC) = 5
Parameter #9(CF_SQL_VARCHAR) = HER
Parameter #10(CF_SQL_VARCHAR) = RI
Parameter #11(CF_SQL_VARCHAR) = 01-Apr-2013
Parameter #12(CF_SQL_VARCHAR) = 31-Mar-2014
Parameter #13(CF_SQL_NUMERIC) = 5
Parameter #14(CF_SQL_VARCHAR) = HER
Parameter #15(CF_SQL_VARCHAR) = RI
Parameter #16(CF_SQL_VARCHAR) = RI
Parameter #17(CF_SQL_VARCHAR) = HER

qLenders (Datasource=star_read, Time=15ms, Records=1) in /data/cf_code/estar/ia/new_homes/partners/qry_showstateresults_partners.cfm @ 12:48:42.042
SELECT
	hd.o_id,
	hd.organization_formal_name,
	hd.o_web_address,
	hd.o_phone1,
	hd.partner_since,
	hd.a_start_date,
	hd.incentive_cat,
	hd.incentive_details
FROM
	homes_locator_data hd,
	homes_service_area hs,
	ref_msa rm
WHERE
	rm.msa_id IN (
		SELECT DISTINCT(msa_id)
		FROM
			xref_msa_location x,
			ref_location_data r
		WHERE
			r.s_code = ?
			AND r.ld_id = x.ld_id
	)
	AND hd.partner_type = ?
	AND hd.o_id = hs.o_id
	AND hs.msa_id = rm.msa_id
ORDER BY
	
	organization_formal_name ASC 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = RI
Parameter #2(CF_SQL_VARCHAR) = LEN

qRatersDistinct (Datasource=, Time=1ms, Records=3) in /data/cf_code/estar/ia/new_homes/partners/qry_showstateresults_partners.cfm @ 12:48:42.042
SELECT DISTINCT o_id
FROM qRaters
qLendersDistinct (Datasource=, Time=2ms, Records=1) in /data/cf_code/estar/ia/new_homes/partners/qry_showstateresults_partners.cfm @ 12:48:42.042
SELECT DISTINCT o_id
FROM qLenders
qOtherCitiesRaw (Datasource=star_read, Time=2ms, Records=0) in /data/cf_code/estar/ia/new_homes/partners/qry_showstateresults_othercities.cfm @ 12:48:42.042
	SELECT hlmd.msa_id, hlmd.other_cities
	  FROM homes_locator_msa_data hlmd, ref_msa rm
	 WHERE hlmd.msa_id=rm.msa_id
	 	   AND rm.s_code = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = RI

qOtherCities (Datasource=, Time=1ms, Records=0) in /data/cf_code/estar/ia/new_homes/partners/qry_showstateresults_othercities.cfm @ 12:48:42.042
	select distinct msa_id,city from qOtherCitiesUnsorted
	order by msa_id, city
getMenuItems (Datasource=, Time=8ms, Records=16) in /data/cf_code/estar/ia/dsp_menu.cfm @ 12:48:42.042
SELECT *
FROM menuItems
ORDER BY
  itemGroup,
  itemOrder


Stored Procedures

PKG_HOMES_LOCATOR.get_dates_for_label (Datasource=star_read, Time=1ms) in /data/cf_code/estar/ia/new_homes/partners/act_getlastfourqtrs.cfm @ 12:48:42.042

    
parameters
typeCFSQLTypevaluevariabledbVarName
 OUT  CF_SQL_DATE    p_startdate = p_startdate  
 OUT  CF_SQL_DATE    p_enddate = p_enddate  
 IN  CF_SQL_VARCHAR  23-Jul-2014    
    
resultsets
nameresultset


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/data/cf_code/estar/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=en-us,en-gb,en;q=0.7,*;q=0.3
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.energystar.gov
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/data/cf_code/estar/index.cfm
QUERY_STRING=fuseaction=new_homes_partners.showStateResults%20&raters_order=DESC&incentives_order=ASC&lenders_by=organization_formal_name&raters_by=qtrTotal&lenders_order=ASC&show=none&msa_id=&incentives_by=partner_since&s_code=RI
REMOTE_ADDR=192.168.15.110
REMOTE_HOST=192.168.15.110
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=www.energystar.gov
SERVER_PORT=8500
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=
WEB_SERVER_API=
URL Parameters:
fuseaction=new_homes_partners.showStateResults 
incentives_by=partner_since
incentives_order=ASC
lenders_by=organization_formal_name
lenders_order=ASC
msa_id=
raters_by=qtrTotal
raters_order=DESC
s_code=RI
show=none
Debug Rendering Time: 23 ms