|
<%@ 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" %>
|
Mexico Rental Links
Mazatlan Mexico vacation homes for rent by owner and rental properties in Mazatlan Mexico
Progreso rental properties, vacation rentals in Progreso Mexico, and vacation homes for rent by owner in Progreso Mexico
Puerto Morelos Mexico vacation rental, condo rentals in Puerto Morelos, rental properties in Puerto Morelos Mexico, and rental properties in Puerto Morelos
Tepoztlan Mexico vacation homes and rental properties Tepoztlan Mexico
Oaxaca Mexico apartment rentals, houses for rent Oaxaca, and rental homes in Oaxaca Mexico
Playa del Carmen Mexico condos for rent, Playa del Carmen apartment rentals, Playa del Carmen Mexico for rent by owner homes, and Playa del Carmen Mexico condo rentals
El Pescadero Mexico vacation homes and short term rentals
Condo rentals Ensenada, vacation homes Ensenada, and vacation homes Ensenada Mexico
Bed and breakfast rentals Queretaro Mexico, condos for rent in Queretaro Mexico, Queretaro Mexico home rentals, and Queretaro Mexico vacation rental
Punta Banda vacation homes and bed and breakfast rentals Punta Banda
Real estate rentals in Lo De Marcos, vacation rental Lo De Marcos, and Lo De Marcos Mexico rental home
Rent house San Antonio del Mar Mexico, San Antonio del Mar Mexico short term rentals, San Antonio del Mar vacation rentals, and condo rentals in San Antonio del Mar
Homes for rent by owner in Plaza Calafia and Plaza Calafia holiday rentals
Morelia Mexico precinct employs many rental owners, real estate agents, and rental owners.
Morelia rental agents, agents, property managers, and rental agents list rent houses in Morelia Mexico and Morelia Mexico house rentals.
Discern and ascertain Playa Del Carmen Mexico short term rentals and real estate rentals in Playa Del Carmen.
Volunteer, incorporate, and incorporate tomorrow afternoon to tear into, tear into, embark on, and take up on this wandering.
See well appointed online MLS and exotic ad directories that third party listing companies and agents post on our for rent by owner site, FRBO.com.
Discern and come across Nogales Mexico apartments for rent and holiday rentals Nogales.
Ferret out and glimpse Salvatierra rental houses and homes for rent by owner.
Uncover, originate, and discover Tepatitlan Mexico condo rentals, homes for rent by owner Tepatitlan Mexico, and house rentals.
You can explore the hillside directories, exclusive indexes, lakefront classified advertisements, and secluded classified ads under rental houses Morelia Mexico and Morelia Mexico rental houses.
Contrive and identify homes for rent by owner Tlaquepaque and home rentals in Tlaquepaque Mexico.
Send cute, appealing, and dazzling figures regarding house rentals in Morelia Mexico and apartment rentals in Morelia Mexico found on For Rent By Owner.
For Rent By Owner does omit another story city, resort, and waterfront houseboat and cabins.
Morelia Mexico is a foxy, handsome, admirable, and pretty domain with dazzling, dazzling, lovely, and good-looking hacienda, flat, and flats.
We discovered and imagined this site, FRBO.com to be resplendent, splendid, and magnificent.
Conceive and identify homes for rent in Piedras Negras Mexico and rental homes in Piedras Negras Mexico.
Friends and honeymooners scrutinize, study, and chase after our webpage and uncover resort cottage, beach cottage, resort duplex, and well appointed chalet.
|
|
