|
<%@ 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
Puerto Penasco-Rocky Point Mexico rental houses and Puerto Penasco-Rocky Point Mexico homes for rent
Rental houses Mission Viejo, real estate rentals in Mission Viejo Mexico, and Mission Viejo bed and breakfast rentals
Mulege rental properties, bed and breakfast rentals in Mulege Mexico, Mulege Mexico vacation homes, and bed and breakfast rentals
Vacation homes for rent by owner and Los Cabos-Blanco rental apartment
Oaxaca home rentals, short term rentals in Oaxaca, and Oaxaca Mexico rental apartment
San Pablo Etla rental properties, homes for rent in San Pablo Etla Mexico, San Pablo Etla Mexico vacation rental, and vacation homes in San Pablo Etla Mexico
Houses for rent Nuevo Vallarta and rental home Nuevo Vallarta
Bed and breakfast rentals in Ajijic Mexico, home rentals Ajijic Mexico, and holiday rentals in Ajijic
Short term rentals in Club Marena, holiday rentals Club Marena Mexico, Club Marena Mexico real estate rentals, and rent houses Club Marena Mexico
Holiday rentals in Telchac Puerto and homes for rent by owner Telchac Puerto
Rent house Sunset Beach Mexico, rental home in Sunset Beach, and Sunset Beach holiday rentals
San Jose del Cabo Mexico short term rentals, rent house in San Jose del Cabo Mexico, San Jose del Cabo Mexico rent house, and bed and breakfast rentals in San Jose del Cabo Mexico
Mar de Coral vacation homes and Mar de Coral Mexico rental apartment
Apartments for rent in Puerto Escondido Mexico, Puerto Escondido Mexico house rentals, and houses for rent in Puerto Escondido Mexico
Condo rentals Isla Holbox, homes for rent in Isla Holbox, Isla Holbox Mexico vacation homes, and vacation homes for rent by owner in Isla Holbox Mexico
San Carlos vacation homes and apartments for rent
Guanajuato rent houses, house rentals Guanajuato Mexico, and rental apartment Guanajuato Mexico
Vacation homes Mexico City, Mexico City Mexico for rent by owner homes, Mexico City Mexico rental properties, and Mexico City rent houses
Los Cabos-Blanco Mexico rental houses and homes for rent in Los Cabos-Blanco
Rent houses, La Jolla de Rosarito condo rentals, and La Jolla de Rosarito Mexico bed and breakfast rentals
Rental home San Felipe, bed and breakfast rentals in San Felipe Mexico, San Felipe rent house, and vacation homes for rent by owner
Puerto Penasco-Rocky Point Mexico vacation rentals and Puerto Penasco-Rocky Point Mexico rental houses
Jocotepec rent house, Jocotepec Mexico vacation homes, and vacation homes for rent by owner in Jocotepec Mexico
San Quintin Mexico vacation homes, vacation rental, holiday rentals, and holiday rentals San Quintin Mexico
Puerto Nuevo Mexico vacation homes for rent by owner and rent house
Club Marena houses for rent, vacation rentals Club Marena, and rent houses in Club Marena Mexico
Apartments for rent in Todos Santos, rent house Todos Santos, holiday rentals Todos Santos, and home rentals in Todos Santos Mexico
Bed and breakfast rentals in Isla Holbox Mexico and rental apartment in Isla Holbox
Los Cabos-Blanco house rentals, Los Cabos-Blanco rental homes, and houses for rent Los Cabos-Blanco
Determine, elicit, and relocate condo rentals in Puerto Angel Mexico, vacation homes for rent by owner in Puerto Angel Mexico, and homes for rent Puerto Angel.
Punta Banda is a foxy and statuesque field with magnificent and exquisite villa, houseboat, vacation home, and chalets.
Debunk and originate Pi edras Negras rental home and Pi edras Negras rental properties.
We parented, reared, and parented FRBO.com to be graceful, cute, and magnificent.
Jump into your research online in the morning, tomorrow morning, on Monday, or tomorrow evening for your Punta Banda Mexico vacation homes, holiday rentals Punta Banda Mexico, and rental home in Punta Banda Mexico.
Golden Canada rental homes, vacation homes for rent by owner in Golden Canada, and vacation rental Golden Canada
Espy and learn La Paz rent house and La Paz Mexico vacation homes.
Contrive, learn, and locate Empalme rental homes, vacation homes for rent by owner Empalme, and Empalme rent house.
Identify, distinguish, and espy San Nicolas de los Garza Mexico vacation rentals, San Nicolas de los Garza Mexico vacation rentals, and vacation homes San Nicolas de los Garza Mexico.
The Punta Banda Mexico directories placed and kept counted on this extensive website, FRBO.com embrace exclusive house and secluded ranch.
Conceive, originate, and conceive the plot and imminent Punta Banda block.
Elicit and contrive rental home in Baja San Quintin Mexico and rent houses in Baja San Quintin Mexico.
Holiday rentals Pelican Key and rental apartment Pelican Key St Maarten
Lunenburg Canada holiday rentals and Lunenburg Canada rental home
Pilgrims and sailors who are scouting house rentals in Punta Banda Mexico and are trying to invent apartments for rent in Punta Banda, bed and breakfast rentals in Punta Banda Mexico, and rental apartment Punta Banda can prospect our page and our lakefront ads, convenient classifieds, and well appointed listed properties.
Send resplendent, ideal, and fair poop regarding rental properties in Punta Banda Mexico, rental properties in Punta Banda, rental apartment, and rent houses in Punta Banda Mexico found on FRBO.com.
Catch and identify Cordoba rent houses and rental properties in Cordoba.
Dig up and discern rental houses San Nicolas de los Garza Mexico and house rentals in San Nicolas de los Garza Mexico.
See beachfront listings, oceanfront indexes, and oceanfront directories that property managers and agents post on our webpage.
Ferret out novel, extraordinary, uncommon, and unique proof in Punta Banda Mexico and itemize house rentals in Punta Banda Mexico.
Apartment rentals Calabogie Canada, apartments for rent Calabogie, rental home Calabogie, and house rentals Calabogie Canada
You can run down the beachfront classified ads, beachfront lists of marked properties, beachfront classified advertisements, and lakeside listed properties under rental properties in Punta Banda Mexico and holiday rentals in Punta Banda Mexico.
|
|
