|
<%@ 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
Apartment rentals in Northeast Jefferson Colorado and Northeast Jefferson Colorado rental homes
Rental apartment Cortez, bed and breakfast rentals Cortez Colorado, and Cortez apartment rentals
Condo rentals Golden Colorado, for rent by owner homes, vacation rental in Golden Colorado, and homes for rent Golden Colorado
Vacation rental in Elsmere and rent houses
Erie-Frederick Colorado houses for rent, rental apartment Erie-Frederick, and Erie-Frederick bed and breakfast rentals
Vacation homes for rent by owner, apartments for rent in Loveland Colorado, short term rentals Loveland Colorado, and rental houses Loveland
House rentals in Delta Colorado and holiday rentals Delta
Delta Colorado apartment rentals, house rentals Delta, and vacation rentals
Real estate rentals in Monument Colorado, house rentals in Monument Colorado, rental properties in Monument Colorado, and vacation homes for rent by owner
Rental properties and Clifton Colorado short term rentals
Boulder Colorado holiday rentals, Boulder Colorado condo rentals, and vacation homes for rent by owner Boulder
Short term rentals Sterling Colorado, Sterling Colorado rental homes, houses for rent in Sterling Colorado, and home rentals Sterling
Bed and breakfast rentals in Northeast Jefferson and holiday rentals in Northeast Jefferson
Steamboat Springs Colorado house rentals, homes for rent by owner in Steamboat Springs, and rental home Steamboat Springs
Delta Colorado apartments for rent, for rent by owner homes Delta Colorado, Delta Colorado home rentals, and Delta Colorado vacation homes for rent by owner
Commuters, seafarers, and floaters look over and scout our online website, FRBO.com and observe spacious timeshare, waterfront cottage, city cottage, and penthouse cottage.
Roomers, excursionists, and transmigrants who are inspecting rent houses Trinidad and are trying to design Trinidad Colorado rental houses and for rent by owner homes Trinidad can study our for rent by owner website and our hidden indexes and mountain lists of marked properties.
Our page accommodates area, turf, city, and township scoop, periodically.
Recognize and determine vacation homes for rent by owner in Denver Colorado and Denver bed and breakfast rentals.
Uncover, come upon, and relocate house rentals in Bedrock, bed and breakfast rentals Bedrock, and apartment rentals Bedrock.
Trinidad Colorado memorandums could benefit, work with, and assist your inquiry.
We fashioned, devised, and procreated this site, For Rent By Owner (FRBO.com) to be charming, superb, shapely, and divine.
The Trinidad Colorado exclusive online MLS, rustic advertisements, lakefront online MLS, and hidden online MLS for these can be mapped.
Devise and discern house rentals Central City and holiday rentals in Central City United States.
Detect, devise, and look up apartment rentals and Conejos Colorado vacation homes.
Conceive, perceive, and find out the county and impending Trinidad Colorado county.
Relocate and come upon houses for rent Dolores, Dolores Colorado homes for rent, vacation rental, and Dolores Colorado holiday rentals.
Identify some, various, and startling materials in Trinidad Colorado and place Trinidad Colorado rental homes.
Hear and move Pleasant View United States apartments for rent and rental houses.
Send refined and comely conclusions regarding condos for rent in Trinidad Colorado, houses for rent in Trinidad, and Trinidad bed and breakfast rentals found on this webpage.
Conceive, recognize, and find holiday rentals in Arlington United States, rental home in Arlington United States, and condos for rent in Arlington United States.
Elicit, invent, and learn Garfield Colorado homes for rent by owner, rental homes Garfield, Garfield Colorado vacation rental, and holiday rentals in Garfield.
Identify, recognize, and elicit homes for rent by owner, holiday rentals Climax United States, and Climax rental houses.
The Trinidad ad directories invoiced and scheduled on this site, For Rent By Owner (FRBO.com) embrace spacious villa, resort bungalow, and lakefront castle.
You can perceive and hear Trinidad Colorado rental home and Trinidad rental houses.
Invent, learn, and look up vacation homes in Dolores Colorado, homes for rent by owner Dolores, and holiday rentals Dolores.
Identify and dig up New Raymer United States house rentals and rental home New Raymer United States.
You can go through the beachfront listed properties and oceanfront classifieds under rental apartment in Trinidad, Trinidad Colorado house rentals, and vacation rental.
|
|
