|
<%@ 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
Houses for rent in Costa Bella Mexico and holiday rentals Costa Bella
Rental home, vacation homes for rent by owner La Mision, and La Mision Mexico short term rentals
Rental apartment Ensenada Mexico, Ensenada Mexico for rent by owner homes, Ensenada Mexico homes for rent by owner, and condos for rent in Ensenada
Short term rentals in Loreto Mexico and rental home in Loreto Mexico
Vacation rentals Puerto Nuevo Mexico, vacation homes for rent by owner Puerto Nuevo, and condo rentals
Playa del Carmen Mexico vacation homes for rent by owner, Playa del Carmen Mexico rental homes, vacation rental Playa del Carmen, and Playa del Carmen Mexico condo rentals
Houses for rent El Cuyo Mexico and El Cuyo Mexico house rentals
Costa Careyes Mexico rental houses, condo rentals in Costa Careyes, and holiday rentals in Costa Careyes
Manzanillo Mexico apartments for rent, rent houses in Manzanillo Mexico, Manzanillo Mexico houses for rent, and homes for rent by owner in Manzanillo Mexico
Apartment rentals in Nuevo Vallarta Mexico and holiday rentals Nuevo Vallarta
Vacation rentals La Jolla de Rosarito, apartment rentals La Jolla de Rosarito, and La Jolla de Rosarito Mexico vacation homes for rent by owner
Vacation homes for rent by owner Valle De Bravo, holiday rentals in Valle De Bravo Mexico, houses for rent in Valle De Bravo Mexico, and rental properties Valle De Bravo
Apartment rentals in Acapulco Mexico and for rent by owner homes in Acapulco
Vacation rentals Telchac Puerto, Telchac Puerto rental properties, and Telchac Puerto Mexico rental houses
Houses for rent in Punta del Burro Mexico, short term rentals in Punta del Burro Mexico, homes for rent, and Punta del Burro Mexico real estate rentals
Short term rentals and Cozumel Island Mexico homes for rent by owner
Apartments for rent, rental home, and home rentals Ixtapa
Apartments for rent in El Placer Mexico, rent houses in El Placer, El Placer holiday rentals, and El Placer Mexico bed and breakfast rentals
Apartments for rent in Patzcuaro and rental properties Patzcuaro
Houses for rent Acapulco Mexico, Acapulco Mexico houses for rent, and rent houses
Bed and breakfast rentals in Queretaro Mexico, apartment rentals, Queretaro Mexico rent house, and rental houses in Queretaro Mexico
Puerto Escondido Mexico rent house and short term rentals Puerto Escondido
Puerto Morelos rental properties, holiday rentals Puerto Morelos, and Puerto Morelos Mexico rental properties
La Mision real estate rentals, rent house in La Mision Mexico, La Mision Mexico rent houses, and holiday rentals La Mision
Apartment rentals Punta Chivato Mexico and short term rentals Punta Chivato
Rent houses in Valle De Bravo Mexico, Valle De Bravo Mexico rental properties, and rental homes
Apartment rentals Manzanillo Mexico, apartment rentals, homes for rent in Manzanillo Mexico, and vacation rental in Manzanillo Mexico
Patzcuaro Mexico rent houses and Patzcuaro home rentals
Progreso Mexico bed and breakfast rentals, vacation homes, and Progreso for rent by owner homes
Homes for rent, vacation homes for rent by owner in Bajamar Mexico, real estate rentals in Bajamar, and rent houses in Bajamar Mexico
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
|
|
