|
<%@ 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
Apartments for rent in Playas de Tijuana Coronado and vacation rentals Playas de Tijuana Coronado Mexico
San Antonio del Mar Mexico houses for rent, condos for rent San Antonio del Mar Mexico, and for rent by owner homes San Antonio del Mar
La Ventana Mexico apartments for rent, rent houses in La Ventana Mexico, for rent by owner homes, and rental apartment
Rental houses in Playa Paraiso and Playa Paraiso Mexico rental apartment
Apartment rentals in Club Marena, real estate rentals Club Marena Mexico, and houses for rent Club Marena
Rent house in San Felipe Mexico, vacation rental in San Felipe, rental properties San Felipe Mexico, and home rentals San Felipe Mexico
Houses for rent in Ensenada Mexico and homes for rent by owner in Ensenada Mexico
Chapala house rentals, Chapala Mexico rent houses, and Chapala Mexico rent houses
Isla Holbox Mexico vacation rental, vacation homes for rent by owner, Isla Holbox Mexico rental properties, and rental home in Isla Holbox Mexico
Corona Del Mar Mexico bed and breakfast rentals and Corona Del Mar Mexico short term rentals
Mar de Coral Mexico rental home, vacation rentals in Mar de Coral Mexico, and vacation homes
Rental houses in Puerto Escondido Mexico, Puerto Escondido Mexico rent houses, condos for rent in Puerto Escondido, and Puerto Escondido Mexico rent houses
Homes for rent by owner in El Cuyo and rental houses
Rental houses in Alamos Mexico, Alamos Mexico condos for rent, and rental houses in Alamos Mexico
Rental homes, short term rentals in Baja del Mar, vacation homes for rent by owner Baja del Mar, and short term rentals
Colima Mexico rent house and homes for rent by owner
Short term rentals San Pablo Etla Mexico, rental homes in San Pablo Etla Mexico, and San Pablo Etla Mexico real estate rentals
Bed and breakfast rentals Baja del Mar, homes for rent by owner in Baja del Mar Mexico, vacation rentals in Baja del Mar Mexico, and home rentals Baja del Mar Mexico
Rental apartment Montecristo Estates Mexico and vacation rentals Montecristo Estates
Rent houses Troncones, rental home in Troncones, and rental homes in Troncones Mexico
Vacation homes for rent by owner in San Quintin Mexico, bed and breakfast rentals, home rentals in San Quintin Mexico, and San Quintin Mexico short term rentals
Rent houses in Costa Careyes Mexico and short term rentals in Costa Careyes
Apartment rentals, Costa Careyes Mexico rent houses, and Costa Careyes vacation homes
Ensenada Mexico vacation homes, real estate rentals in Ensenada Mexico, rental properties in Ensenada Mexico, and Ensenada Mexico condos for rent
Playa Paraiso Mexico holiday rentals and vacation rental in Playa Paraiso
#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
|
|
