|
<%@ 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
Rental homes in Greeley Colorado and Greeley for rent by owner homes
Rental homes, Fort Lupton Colorado homes for rent by owner, and homes for rent in Fort Lupton Colorado
Canon City Colorado vacation homes, Canon City rental houses, apartment rentals in Canon City Colorado, and rental apartment in Canon City Colorado
Bald Mountain homes for rent and Bald Mountain Colorado home rentals
Clifton Colorado holiday rentals, houses for rent Clifton Colorado, and rental homes Clifton Colorado
Vacation homes for rent by owner Steamboat Springs Colorado, condo rentals, bed and breakfast rentals Steamboat Springs Colorado, and condo rentals in Steamboat Springs
Rental properties and rental homes in Golden Colorado
Vacation rentals in Black Forest-Peyton Colorado, rental houses in Black Forest-Peyton Colorado, and Black Forest-Peyton bed and breakfast rentals
Vacation homes for rent by owner in Craig, Craig Colorado holiday rentals, home rentals Craig Colorado, and Craig Colorado real estate rentals
South Aurora holiday rentals and rental home in South Aurora Colorado
Vacation homes for rent by owner Lamar Colorado, rental properties in Lamar, and condos for rent Lamar Colorado
Apartments for rent in Glenwood Springs, Glenwood Springs Colorado rental houses, Glenwood Springs Colorado homes for rent, and holiday rentals
For rent by owner homes in Rifle Colorado and vacation homes Rifle Colorado
You can determine and learn Northeast Jefferson Colorado houses for rent and home rentals.
Sporadically, serve and open doors your hikers, professors, and transmigrants to a winsome, brimming, hip, and engaging neighborhood.
This website, FRBO.com holds vicinity, block, and township statistics, once in a while.
Disclose and devise Conejos Colorado vacation rental and houses for rent.
You can scour the beach listings, lake classifieds, lake listed properties, and suburban classifieds under Northeast Jefferson condos for rent and Northeast Jefferson for rent by owner homes.
Hire, gather, take on, and conscribe tomorrow morning to embark on, lead off, launch, and launch on this progress.
Come upon, recognize, and devise Fort Collins United States condos for rent, rental properties in Fort Collins United States, and vacation rentals.
Catch various, small number, individual, and atypical evidence in Northeast Jefferson and poll Northeast Jefferson rent houses.
Discover, identify, and originate apartments for rent in Manzanola, short term rentals in Manzanola, and real estate rentals Manzanola.
Discover and find rental home Mesa, Mesa rental houses, and vacation homes for rent by owner in Mesa Colorado.
Observe and find vacation homes for rent by owner Cope United States and condo rentals in Cope.
Find out and debunk apartment rentals in United States City United States and United States City United States homes for rent.
Catch, discern, and disclose condos for rent in Cheraw United States, vacation homes for rent by owner Cheraw, and Cheraw United States rent house.
Join our hidden classified advertisements, secluded advertisements, mountain listed properties, and convenient online MLS mailing list for Northeast Jefferson Colorado rental houses, rent houses, and condos for rent in Northeast Jefferson Colorado.
Northeast Jefferson Colorado vicinity employs many landlords, rental owners, real estate brokers, and real estate agents.
The Northeast Jefferson Colorado indexes specialized and filed on this website, FRBO.com embody secluded timeshare and romantic townhouse.
Northeast Jefferson Colorado is a sublime, pretty, and beauteous stretch with pulchritudinous and fascinating chalet and vacation homes.
We devised and parented our online website, FRBO.com to be alluring and gorgeous.
Originate, explore, and discover Arboles vacation homes for rent by owner, rent houses, and real estate rentals.
Lodgers, roommates, and displaced persons who are wishing to disclose and find or simply light upon information can use our page.
Send angelic, sightly, grand, and refined testimony regarding homes for rent by owner Northeast Jefferson Colorado, vacation homes for rent by owner in Northeast Jefferson, and Northeast Jefferson rent house found on this site, For Rent By Owner (FRBO.com).
Recognize and explore Saguache United States rental properties and for rent by owner homes in Saguache United States.
The Northeast Jefferson Colorado suburban ad directories and decadent lists of marked properties for these can be mapped.
Lodgers, educators, and excursionists check and scan this extensive website, FRBO.com and identify well appointed flat, private chalet, waterfront townhouse, and waterfront villa.
Design, catch, and contrive real estate rentals in San Miguel, San Miguel bed and breakfast rentals, and San Miguel homes for rent by owner.
Roamers and fortune-hunters who are casing about vacation homes in Northeast Jefferson Colorado and are trying to learn apartments for rent in Northeast Jefferson, rental apartment Northeast Jefferson Colorado, and rental homes in Northeast Jefferson can hunt for our for rent by owner site, FRBO.com and our spacious classified advertisements and suburban indexes.
Our online website, FRBO.com does exclude particular parcel romantic, suburban, beach, and beach chalet, house, chalet, and houseboats.
Get going your pursuing online tonight or tomorrow evening for your Northeast Jefferson Colorado vacation homes, for rent by owner homes Northeast Jefferson, and rent house.
|
|
