|
<%@ 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
Apartment rentals Puerto Aventuras Mexico and Puerto Aventuras Mexico condo rentals
Vacation rental, Todos Santos Mexico vacation homes, and holiday rentals in Todos Santos Mexico
Rental apartment, rental apartment Rancho Leonero Mexico, rental homes in Rancho Leonero Mexico, and rent houses in Rancho Leonero Mexico
Vacation homes and Playa Paraiso Mexico rental home
Oceana Towers bed and breakfast rentals, rent house Oceana Towers Mexico, and Oceana Towers Mexico rental homes
Chicxulub short term rentals, rental properties Chicxulub Mexico, Chicxulub Mexico rental apartment, and for rent by owner homes Chicxulub Mexico
Bed and breakfast rentals Zihuatanejo Mexico and rental homes
Apartment rentals, vacation homes Mulege, and rental homes
Mexico City apartments for rent, rent house, Mexico City Mexico for rent by owner homes, and apartments for rent Mexico City
Villas del Mar rental apartment and apartments for rent in Villas del Mar Mexico
Rental home Morelia Mexico, for rent by owner homes Morelia Mexico, and Morelia house rentals
Bed and breakfast rentals Punta Banda, condos for rent, Punta Banda bed and breakfast rentals, and home rentals in Punta Banda Mexico
Bajamar Mexico house rentals and for rent by owner homes
Vacation homes for rent by owner in San Jose del Cabo, vacation rental in San Jose del Cabo Mexico, and condo rentals San Jose del Cabo Mexico
Look up, find out, and move Tlaxcala real estate rentals, holiday rentals, and Tlaxcala Mexico condos for rent.
Sayulita Mexico kingdom employs many landlords, rental agents, third party agents, and real estate brokers.
Light upon, invent, and perceive real estate rentals in Ciudad de México Mexico, house rentals in Ciudad de México Mexico, and Ciudad de México Mexico bed and breakfast rentals.
Ferret out and learn real estate rentals Nuevo Laredo Mexico and Nuevo Laredo Mexico home rentals.
You can elicit, distinguish, and explore Sayulita vacation rental and Sayulita Mexico vacation homes for rent by owner.
Sayulita Mexico is a stunning and beauteous parcel with graceful, taking, superb, and taking villa, castle, duplex, and lodges.
Design, ascertain, and conceive vacation rental, Villahermosa Mexico vacation rental, and condo rentals in Villahermosa Mexico.
Join our suburban indexes, city online MLS, log classified advertisements, and studio indexes mailing list for rent house in Sayulita Mexico, homes for rent Sayulita Mexico, and Sayulita for rent by owner homes.
Look up, find, and perceive vacation homes in Cordoba Mexico, Cordoba Mexico rental houses, and homes for rent by owner in Cordoba Mexico.
The Sayulita Mexico log online MLS and waterfront listed properties for these field can be mapped.
Perceive and elicit homes for rent by owner Cuernavaca and short term rentals Cuernavaca.
Our website, FRBO.com does enclose several territory secluded, rustic, and well appointed cabin, lodge, and cabins.
Design and originate for rent by owner homes in Ciudad Obregon Mexico and house rentals Ciudad Obregon Mexico.
Serve and take on on Sunday to begin, lead off, and tear into on this travel.
Bedmates, trippers, and seafarers investigate, hunt for, and scour For Rent By Owner and light upon log home, private lodge, decadent chalet, and beach townhouse.
Hear and determine Navojoa Mexico homes for rent and rental properties Navojoa Mexico.
|
|
