|
<%@ 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 in Puerto Nuevo Mexico and Puerto Nuevo Mexico vacation homes for rent by owner
Real estate rentals in Oceana Towers Mexico, apartment rentals Oceana Towers Mexico, and home rentals in Oceana Towers
Los Cabos-Blanco Mexico bed and breakfast rentals, houses for rent Los Cabos-Blanco Mexico, vacation homes in Los Cabos-Blanco Mexico, and houses for rent in Los Cabos-Blanco
Vacation rentals Soliman Bay and apartment rentals in Soliman Bay Mexico
Playa Paraiso Mexico bed and breakfast rentals, holiday rentals Playa Paraiso Mexico, and homes for rent by owner Playa Paraiso
Condo rentals, bed and breakfast rentals Rancho Leonero, Rancho Leonero Mexico vacation rentals, and vacation rentals in Rancho Leonero Mexico
Bajamar Mexico holiday rentals and rental apartment in Bajamar
Loreto Mexico apartment rentals, homes for rent Loreto Mexico, and Loreto Mexico houses for rent
Vacation homes in Cozumel Island Mexico, vacation rental in Cozumel Island Mexico, vacation homes for rent by owner, and homes for rent
Houses for rent in Manzanillo Mexico and bed and breakfast rentals in Manzanillo
Homes for rent by owner Punta Banda, rental properties in Punta Banda, and rent house Punta Banda
Rental properties in Baja Malibu Mexico, condos for rent Baja Malibu Mexico, Baja Malibu Mexico condo rentals, and Baja Malibu Mexico house rentals
Chicxulub Mexico holiday rentals and apartment rentals in Chicxulub Mexico
Rental homes in Colima Mexico, short term rentals Colima, and condos for rent
Isla Navidad apartments for rent, condo rentals in Isla Navidad Mexico, Isla Navidad Mexico short term rentals, and Isla Navidad bed and breakfast rentals
Apartment rentals Mulege Mexico and vacation rental Mulege
Costa Careyes Mexico vacation homes, homes for rent, and real estate rentals Costa Careyes Mexico
Punta Banda Mexico homes for rent, Punta Banda Mexico house rentals, holiday rentals in Punta Banda, and holiday rentals Punta Banda
Houses for rent Baja del Mar and home rentals Baja del Mar Mexico
Homes for rent Mission Viejo, Mission Viejo for rent by owner homes, and rental properties Mission Viejo
Real estate rentals Isla Holbox Mexico, rental apartment in Isla Holbox, houses for rent Isla Holbox Mexico, and rental houses
Rental houses in Teacapan Mexico and vacation rentals in Teacapan Mexico
Apartments for rent, rent house in Merida, and condos for rent
La Mision for rent by owner homes, La Mision Mexico rental home, rental houses in La Mision, and short term rentals La Mision Mexico
Holiday rentals Playa del Secreto and apartments for rent Playa del Secreto
Vacation homes for rent by owner Alamos Mexico, holiday rentals in Alamos Mexico, and homes for rent in Alamos Mexico
Rent houses in Cabo San Lucas Mexico, Cabo San Lucas Mexico rent houses, Cabo San Lucas bed and breakfast rentals, and Cabo San Lucas rental properties
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
|
|
