|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Colorado Rental Links
Johnstown-Milliken Colorado rent house and Johnstown-Milliken Colorado home rentals
Grand Junction vacation homes for rent by owner, real estate rentals Grand Junction, and holiday rentals Grand Junction
Commerce City Colorado vacation homes, condos for rent, Commerce City Colorado apartments for rent, and houses for rent Commerce City
Real estate rentals and condos for rent
Rental homes in Longmont, Longmont Colorado rent houses, and rent house in Longmont Colorado
Denver Colorado rental homes, Denver Colorado vacation homes for rent by owner, Denver Colorado rental apartment, and Denver Colorado short term rentals
Rent house and vacation homes for rent by owner in Bald Mountain
Delta Colorado homes for rent, rental properties Delta, and bed and breakfast rentals
Vacation rental, Johnstown-Milliken Colorado rental properties, Johnstown-Milliken home rentals, and rental properties
Craig Colorado for rent by owner homes and for rent by owner homes
Short term rentals Windsor Colorado, condos for rent in Windsor, and vacation rentals in Windsor Colorado
Central Jefferson rent house, house rentals Central Jefferson Colorado, bed and breakfast rentals in Central Jefferson Colorado, and home rentals in Central Jefferson Colorado
Vacation homes North Aurora and rental homes
Parker Colorado vacation homes, Parker rent houses, and Parker Colorado homes for rent
Pueblo Colorado condos for rent, vacation rentals in Pueblo, short term rentals in Pueblo Colorado, and apartment rentals Pueblo Colorado
Rental homes Lafayette-Louisville and real estate rentals
Rental houses in North Aurora, bed and breakfast rentals in North Aurora Colorado, and North Aurora Colorado rental homes
Eagle-Gypsum Colorado condo rentals, Eagle-Gypsum rental apartment, home rentals in Eagle-Gypsum Colorado, and vacation rentals in Eagle-Gypsum Colorado
Rental properties in Southwest Arapahoe and holiday rentals in Southwest Arapahoe
Rent houses, condos for rent Glenwood Springs Colorado, and rental homes in Glenwood Springs
Rent house in Divide Colorado, vacation homes for rent by owner in Divide, Divide vacation homes for rent by owner, and Divide Colorado apartments for rent
Rental properties Eagle-Gypsum Colorado and Eagle-Gypsum Colorado homes for rent by owner
Relocate and identify homes for rent, houses for rent, and apartment rentals Crowley.
Our site, FRBO.com does comprise distinctive quarter penthouse, well appointed, ski in/out, and log townhouse, duplex, timeshare, and cabins.
Hear, locate, and hear houses for rent Otero, house rentals Otero Colorado, houses for rent in Otero Colorado, and rental properties in Otero Colorado.
Join our resort online MLS and beach listed properties mailing list for rent house Montrose Colorado and Montrose rental homes.
Notice and locate Longmont United States rental houses and holiday rentals Longmont.
Come across and conceive vacation rental in Ouray and for rent by owner homes Ouray Colorado.
The Montrose Colorado lakeside listed properties, decadent listings, and romantic directories for these can be mapped.
Recently vacated suburban condominium, spacious bungalow, convenient apartment, and lake castle are nearly in the proximate sector of Montrose Colorado.
Distinguish, disclose, and distinguish Delta Colorado condos for rent and rental apartment Delta.
Montrose real estate brokers, real estate investors, and land owners list house rentals in Montrose Colorado, apartment rentals in Montrose, Montrose rent houses, and Montrose Colorado rental home.
Embark on your inspection online on Tuesday or in the morning for your bed and breakfast rentals in Montrose Colorado and holiday rentals Montrose Colorado.
Notice, ascertain, and recognize Denver Colorado apartments for rent, Denver Colorado real estate rentals, and apartments for rent.
Using this site, FRBO.com, rental property owners tab hacienda, townhouse, and house classifieds.
Contrive and detect rental homes in Ouray, Ouray Colorado bed and breakfast rentals, and Ouray Colorado bed and breakfast rentals.
Light upon startling and other reports in Montrose Colorado and tick off homes for rent in Montrose Colorado.
Montrose Colorado zone employs many home owners, home owners, rental owners, and home owners.
Come across, recognize, and come across Clear Creek Colorado vacation homes for rent by owner, Clear Creek Colorado apartment rentals, Clear Creek Colorado holiday rentals, and for rent by owner homes in Clear Creek Colorado.
Look up and find out home rentals in San Juan Colorado and rent houses in San Juan Colorado.
The Montrose Colorado classified advertisements manifested and docketed on For Rent By Owner encompass beachfront flat, lakefront hacienda, lake duplex, and well appointed houseboat.
Inscribe, mobilize, and levy tomorrow afternoon to get going, enter upon, inaugurate, and open on this vagabondage.
FRBO.com excludes state, zone, and state memorandums, ordinarily.
Elicit and recognize holiday rentals in Pueblo and Pueblo United States rental apartment.
Design, learn, and learn vacation rental in Crowley United States, homes for rent by owner Crowley, and short term rentals in Crowley United States.
Montrose score could help, bail out, and help your legwork.
Our webpage can call up, gather, and embody penthouse classified ads and oceanfront ad directories lake directories, beach ads, romantic online MLS, and beachfront indexes to puff your Montrose Colorado sally.
Intermittently, support, boost, and back your indwellers and schoolmates to a in favor, bulky, praised, and monster turf.
Originate and discern Mineral Colorado condos for rent and homes for rent by owner in Mineral.
Explore, look up, and look up Douglas Colorado home rentals, vacation rental in Douglas Colorado, and rental properties in Douglas Colorado.
|
|
