|
<%@ 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
Condos for rent and Teacapan apartment rentals
San Blas rental houses, apartments for rent in San Blas Mexico, and San Blas Mexico condos for rent
Rent house in Puerto Aventuras, Puerto Aventuras apartment rentals, Puerto Aventuras short term rentals, and vacation homes for rent by owner in Puerto Aventuras Mexico
Rental home in Rose Mexico and condo rentals in Rose Mexico
La Paloma apartment rentals, vacation rentals in La Paloma Mexico, and La Paloma condo rentals
Manzanillo Mexico home rentals, vacation rental Manzanillo, Manzanillo rent house, and apartment rentals Manzanillo
Real estate rentals La Jolla de Rosarito Mexico and bed and breakfast rentals
Vacation rental in Nuevo Vallarta Mexico, vacation homes for rent by owner Nuevo Vallarta Mexico, and vacation homes for rent by owner in Nuevo Vallarta Mexico
Rent house in Bajamar Mexico, Bajamar vacation homes, house rentals Bajamar, and Bajamar Mexico houses for rent
Rental houses in Bahia Kino-Kino Bay and rental houses in Bahia Kino-Kino Bay
Celestun Mexico short term rentals, homes for rent, and rental homes Celestun Mexico
Apartments for rent Catemaco Mexico, holiday rentals in Catemaco, rental apartment in Catemaco Mexico, and rental home Catemaco
Apartment rentals in Platanitos Mexico and rental apartment in Platanitos Mexico
Vacation homes Ixtapa Mexico, rent house in Ixtapa Mexico, and condo rentals in Ixtapa Mexico
Vacation rental in Xalapa Mexico, house rentals Xalapa, short term rentals in Xalapa Mexico, and rental homes in Xalapa Mexico
Real estate rentals in Bucerias Mexico and condo rentals Bucerias
Rent houses Los Frailes Mexico, short term rentals Los Frailes Mexico, and apartment rentals Los Frailes Mexico
Home rentals, holiday rentals in Punta del Burro Mexico, for rent by owner homes Punta del Burro Mexico, and rental houses
For rent by owner homes in Baja Malibu Mexico and Baja Malibu vacation homes
Apartments for rent in Colima, condos for rent Colima Mexico, and Colima Mexico condos for rent
Condo rentals Mar de Coral Mexico, bed and breakfast rentals in Mar de Coral Mexico, rental homes Mar de Coral Mexico, and apartments for rent in Mar de Coral Mexico
Houses for rent Guanajuato and home rentals in Guanajuato Mexico
Vacation rentals, Isla Holbox apartment rentals, and vacation rental in Isla Holbox Mexico
Apartment rentals in San Francisco-San Pancho Mexico, homes for rent by owner San Francisco-San Pancho, vacation rentals in San Francisco-San Pancho, and house rentals in San Francisco-San Pancho Mexico
Homes for rent by owner in Manzanillo Mexico and Manzanillo Mexico real estate rentals
Vacation rental in Cancun, house rentals Cancun, and homes for rent by owner Cancun
Houses for rent Calafia, rental home in Calafia Mexico, rental home in Calafia Mexico, and rental homes in Calafia
Homes for rent in Queretaro Mexico and apartment rentals in Queretaro Mexico
San Jose del Cabo Mexico homes for rent by owner, rental apartment San Jose del Cabo Mexico, and San Jose del Cabo Mexico house rentals
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
|
|
