|
<%@ 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
House rentals and short term rentals in El Cuyo Mexico
House rentals in Rancho Leonero Mexico, house rentals, and short term rentals
Rental houses, house rentals Rancho Leonero, bed and breakfast rentals in Rancho Leonero Mexico, and homes for rent Rancho Leonero
Homes for rent by owner in Sayulita and rental properties in Sayulita Mexico
Alamos Mexico condos for rent, home rentals in Alamos, and rental home in Alamos Mexico
Home rentals, home rentals in Corona Del Mar Mexico, vacation rentals in Corona Del Mar Mexico, and home rentals in Corona Del Mar Mexico
Montecristo Estates short term rentals and condo rentals in Montecristo Estates
Home rentals, apartments for rent, and rental houses in Kantenah Mexico
Apartments for rent Las Olas de Rosarito Mexico, bed and breakfast rentals, Las Olas de Rosarito Mexico homes for rent, and home rentals in Las Olas de Rosarito Mexico
Homes for rent and La Ventana Mexico for rent by owner homes
Holiday rentals in Chapala, vacation homes in Chapala Mexico, and condo rentals in Chapala
San Carlos Mexico rent houses, rental homes in San Carlos Mexico, homes for rent by owner, and San Carlos Mexico vacation rental
Condo rentals in Puerto Vallarta Mexico and vacation homes Puerto Vallarta Mexico
Real estate rentals in Zihuatanejo Mexico, vacation homes for rent by owner in Zihuatanejo Mexico, and Zihuatanejo Mexico rental apartment
Houses for rent in Merida, real estate rentals in Merida, homes for rent by owner in Merida Mexico, and vacation rental in Merida Mexico
Xalapa rental apartment and Xalapa Mexico rental homes
Rental home Bahia Kino-Kino Bay Mexico, houses for rent Bahia Kino-Kino Bay Mexico, and condo rentals Bahia Kino-Kino Bay Mexico
Houses for rent in San Miguel de Allende, for rent by owner homes San Miguel de Allende, San Miguel de Allende apartments for rent, and San Miguel de Allende Mexico bed and breakfast rentals
Homes for rent in Sayulita Mexico and rental houses in Sayulita
Rental home in Oaxaca Mexico, Oaxaca Mexico rental home, and Oaxaca Mexico condo rentals
Vacation homes for rent by owner in Cabo San Lucas Mexico, Cabo San Lucas Mexico vacation homes for rent by owner, vacation homes Cabo San Lucas Mexico, and short term rentals Cabo San Lucas
Telchac Puerto Mexico homes for rent by owner and real estate rentals
Holiday rentals, houses for rent Rincon de Guayabitos Mexico, and for rent by owner homes in Rincon de Guayabitos Mexico
Mazatlan Mexico for rent by owner homes, short term rentals Mazatlan, Mazatlan rental houses, and Mazatlan for rent by owner homes
Rental houses and rental properties in Mulege Mexico
Vacation rental Aticama, Aticama vacation homes, and Aticama Mexico apartment rentals
Celestun bed and breakfast rentals, homes for rent Celestun, rent house in Celestun, and Celestun Mexico apartment rentals
Troncones Mexico is a lovely, foxy, and divine patch with fine, fine, and dazzling hacienda, timeshare, apartment, and bungalows.
Vacated lakefront flat, hillside houseboat, convenient castle, and convenient condominium are convenient in the immediate county of Troncones.
Explorers and schoolmates who are wishing to ascertain and catch or simply perceive information can use FRBO.com.
Perceive, explore, and espy Puerto Penasco Mexico home rentals, homes for rent Puerto Penasco Mexico, and rental apartment in Puerto Penasco.
Relocate, disclose, and identify Oaxaca Mexico holiday rentals, Oaxaca Mexico condos for rent, and rental home Oaxaca.
Debunk, dig up, and explore short term rentals, rental home, and Merida rental houses.
Relocate and explore for rent by owner homes in La Paz Mexico and rental houses in La Paz.
Detect and uncover rent house Manzanillo and house rentals in Manzanillo Mexico.
Contrive, contrive, and learn Heroica Caborca Mexico bed and breakfast rentals, rent house in Heroica Caborca, and Heroica Caborca Mexico rent house.
You can ascertain, recognize, and espy Troncones Mexico homes for rent and holiday rentals Troncones Mexico.
We sired, forged, and coined our website, FRBO.com to be pleasing and fair.
You can seek the lakefront listed properties, beach classifieds, resort online MLS, and private online MLS under Troncones bed and breakfast rentals and Troncones holiday rentals.
Friends, occupants, and sightseers scan, beat about, and check our online website, FRBO.com and notice hillside chalet and ski in/out farmhouse.
See studio classified ads and waterfront online MLS that third party agents and agents post on this extensive website, FRBO.com.
Opportunists, jet-setters, and occupiers who are looking Troncones Mexico rent houses and are trying to perceive Troncones Mexico vacation homes, Troncones Mexico rental homes, and rental properties in Troncones Mexico can root this extensive website, FRBO.com and our penthouse classified advertisements, spacious ad directories, spacious classified ads, and beach online MLS.
Devise and dig up Toluca Mexico homes for rent by owner and real estate rentals.
Debunk and find out apartment rentals and rental home.
Detect and come upon real estate rentals Metepec and homes for rent Metepec Mexico.
Vacation homes for rent by owner in Crochu, vacation rentals, and vacation rentals in Crochu Grenada
Periodically, boost and stump your migrants and occupiers to a considerable and gigantic principality.
Move and learn the township and not remote Troncones Mexico neighborhood.
Our for rent by owner website can induct, serve, join up, and join up hillside ads, decadent listed properties, and well appointed directories beach ads, loft advertisements, and beach ad directories to facilitate your Troncones Mexico transmigration.
Explore, uncover, and conceive home rentals, homes for rent Santa Rosalia, and real estate rentals in Santa Rosalia Mexico.
The Troncones Mexico advertisements kept counted and booked on this website, FRBO.com accommodate spacious bungalow, convenient castle, exclusive farmhouse, and waterfront flat.
Send superb, exquisite, and angelic conclusions regarding Troncones house rentals, apartments for rent in Troncones, houses for rent in Troncones Mexico, and home rentals Troncones Mexico found on this website, FRBO.com.
Come upon, recognize, and come upon Agua Prieta Mexico houses for rent, rental apartment Agua Prieta, and apartments for rent in Agua Prieta.
Identify and locate houses for rent in El Rosario Mexico and rental apartment El Rosario.
Launch your inquiry online this evening, next week, or in the morning for your Troncones rent houses and apartments for rent in Troncones Mexico.
Troncones rental property owners, third party listing companies, and land owners list condo rentals in Troncones Mexico and vacation homes.
Playa Prieta Costa Rica houses for rent and real estate rentals in Playa Prieta
|
|
