|
<%@ 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
Rental properties Platanitos and rental houses Platanitos
Rental houses in Sunset Beach, Sunset Beach Mexico vacation homes for rent by owner, and apartment rentals in Sunset Beach Mexico
Short term rentals in Manzanillo, rental apartment Manzanillo, Manzanillo Mexico vacation homes for rent by owner, and Manzanillo Mexico rent house
Akumal rental houses and short term rentals
Rental apartment, vacation homes La Paloma, and La Paloma Mexico rental home
Apartment rentals San Blas, San Blas Mexico house rentals, rent houses in San Blas Mexico, and real estate rentals San Blas Mexico
Las Olas de Rosarito bed and breakfast rentals and vacation rentals
Bed and breakfast rentals in Dolores Hidalgo Mexico, house rentals in Dolores Hidalgo Mexico, and rental homes Dolores Hidalgo
Baja del Mar Mexico home rentals, Baja del Mar Mexico holiday rentals, Baja del Mar rental houses, and Baja del Mar vacation rental
Houses for rent in Playa Las Tortugas-Turtle Beach Mexico and condo rentals Playa Las Tortugas-Turtle Beach
Vacation rental in Oceana Towers, Oceana Towers Mexico holiday rentals, and apartment rentals Oceana Towers Mexico
Homes for rent by owner in Calafia, Calafia homes for rent by owner, Calafia Mexico houses for rent, and Calafia Mexico apartments for rent
Puerto Aventuras Mexico vacation homes and rental home Puerto Aventuras
Ensenada Mexico rental properties, vacation rentals, and Ensenada condo rentals
Real estate rentals Xcalak Mexico, rental home, rental home in Xcalak Mexico, and homes for rent in Xcalak Mexico
House rentals San Antonio del Mar and apartments for rent
Punta Chivato rental apartment, rental homes Punta Chivato Mexico, and Punta Chivato Mexico short term rentals
Rental apartment in San Antonio Mexico, San Antonio rental homes, home rentals in San Antonio Mexico, and condo rentals
Los Cabos Corridor Mexico rental apartment and house rentals in Los Cabos Corridor
Vacation rentals in Alamos Mexico, Alamos Mexico rent houses, and house rentals in Alamos Mexico
Las Gaviotas Mexico house rentals, home rentals Las Gaviotas Mexico, Las Gaviotas Mexico vacation homes for rent by owner, and real estate rentals Las Gaviotas
For rent by owner homes Puerto Vallarta and rental home Puerto Vallarta Mexico
Teotitlan del Valle Mexico apartment rentals, bed and breakfast rentals in Teotitlan del Valle, and rental apartment
Holiday rentals in El Placer, holiday rentals, rental apartment El Placer Mexico, and rental houses
San Felipe vacation homes for rent by owner and homes for rent in San Felipe
Bed and breakfast rentals in San Carlos, San Carlos for rent by owner homes, and rental houses in San Carlos Mexico
Troncones Mexico rental houses, vacation rentals, Troncones Mexico house rentals, and Troncones Mexico bed and breakfast rentals
Houses for rent and houses for rent
Real estate rentals in Isla Mujeres, for rent by owner homes in Isla Mujeres Mexico, and real estate rentals Isla Mujeres
#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
|
|
