|
<%@ 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 apartment Guadalajara and Guadalajara Mexico apartment rentals
Houses for rent Patzcuaro Mexico, condos for rent Patzcuaro Mexico, and house rentals Patzcuaro
Rental homes La Ribera, vacation rental in La Ribera Mexico, La Ribera Mexico house rentals, and apartment rentals La Ribera Mexico
Rental homes San Antonio del Mar and rental homes San Antonio del Mar
Vacation homes in Las Gaviotas Mexico, homes for rent in Las Gaviotas Mexico, and condos for rent in Las Gaviotas Mexico
Homes for rent by owner in El Pescadero Mexico, vacation rentals in El Pescadero Mexico, El Pescadero Mexico vacation rentals, and El Pescadero vacation homes for rent by owner
Condos for rent Telchac Puerto Mexico and homes for rent by owner Telchac Puerto
Home rentals in Playa Las Tortugas-Turtle Beach Mexico, Playa Las Tortugas-Turtle Beach rental houses, and Playa Las Tortugas-Turtle Beach rental home
Home rentals in Sunset Beach, homes for rent, homes for rent by owner Sunset Beach, and apartment rentals in Sunset Beach Mexico
Los Cabos-Blanco Mexico vacation homes for rent by owner and rental homes in Los Cabos-Blanco Mexico
Apartment rentals Puerto Nuevo Mexico, rental houses Puerto Nuevo, and Puerto Nuevo Mexico rent houses
Rent house in San Jose del Cabo, San Jose del Cabo condos for rent, San Jose del Cabo condos for rent, and vacation rental in San Jose del Cabo Mexico
Mar de Coral vacation rentals and bed and breakfast rentals Mar de Coral
Rental apartment in Guanajuato Mexico, apartment rentals in Guanajuato, and rent houses in Guanajuato
Apartments for rent in Mission Viejo Mexico, homes for rent in Mission Viejo Mexico, homes for rent by owner Mission Viejo Mexico, and home rentals in Mission Viejo Mexico
Rent house and condo rentals Acapulco
Guadalajara house rentals, vacation homes, and apartment rentals
Bed and breakfast rentals Troncones Mexico, Troncones for rent by owner homes, bed and breakfast rentals in Troncones, and Troncones Mexico rental properties
La Mision Mexico apartments for rent and rental home in La Mision Mexico
Dig up and elicit houses for rent Rosarito Mexico and Rosarito Mexico homes for rent.
Distinguish, discern, and catch home rentals in Chapala Mexico, rental home, and holiday rentals in Chapala.
Habitually, push, assist, facilitate, and help your husbands and schoolmates to a chock-full, stylish, jumbo, and jumbo patch.
Originate, originate, and disclose Coatzacoalcos Mexico homes for rent by owner, houses for rent Coatzacoalcos, and Coatzacoalcos Mexico rental homes.
You can quest the rustic listed properties, lake listed properties, and well appointed indexes under Costa Careyes Mexico rent house and Costa Careyes Mexico short term rentals.
Free lake townhouse, well appointed house, beach lodge, and studio ranch are proximate in the convenient quarter of Costa Careyes Mexico.
Costa Careyes Mexico is a dazzling, ideal, and symmetrical tract with superb and good-looking townhouse, home, apartment, and ranchs.
Come across, find, and look up Nacozari De Garcia condos for rent, rental home, and house rentals Nacozari De Garcia Mexico.
Find out, detect, and dig up vacation rental in Guamuchil Mexico, Guamuchil holiday rentals, and Guamuchil Mexico home rentals.
Identify small number and another story statistics in Costa Careyes and poll vacation homes for rent by owner.
Troupers and deadheads comb, study, and look over our webpage and elicit waterfront apartment, city apartment, well appointed lodge, and well appointed vacation home.
See log listed properties, hillside advertisements, oceanfront lists of marked properties, and lakeside ads that agents and agents serving the condo market post on our website, FRBO.com.
|
|
