|
<%@ 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 houses in Calafia and Calafia Mexico for rent by owner homes
Apartments for rent Acapulco Mexico, apartments for rent Acapulco Mexico, and homes for rent in Acapulco Mexico
Vacation rentals, rental homes La Mision, houses for rent, and La Mision Mexico holiday rentals
Apartment rentals and houses for rent in Playa del Carmen Mexico
Rental home, Bacalar Mexico rental homes, and vacation homes for rent by owner in Bacalar Mexico
Apartments for rent in Teotitlan del Valle, house rentals in Teotitlan del Valle Mexico, Teotitlan del Valle short term rentals, and for rent by owner homes Teotitlan del Valle
Vacation homes for rent by owner Dolores Hidalgo Mexico and condo rentals Dolores Hidalgo
Rental properties Puerto Escondido Mexico, home rentals in Puerto Escondido, and Puerto Escondido rental apartment
La Paloma Mexico vacation rentals, vacation rental La Paloma Mexico, vacation rental La Paloma, and homes for rent by owner in La Paloma Mexico
Houses for rent in Telchac Puerto Mexico and vacation rental in Telchac Puerto
Rental home in Valle De Bravo Mexico, Valle De Bravo rent houses, and short term rentals in Valle De Bravo
Progreso Mexico rental apartment, condo rentals in Progreso Mexico, vacation rental, and homes for rent in Progreso Mexico
San Antonio Mexico rental home and San Antonio Mexico rental home
Chapala condo rentals, condos for rent Chapala Mexico, and holiday rentals
This site, For Rent By Owner (FRBO.com) can reserve, register, serve, and register lakefront indexes, penthouse advertisements, and resort advertisements lake advertisements, lake directories, and rustic ad directories to work with your Cuernavaca Mexico safari.
Pirates and sailors who are wishing to glimpse and conceive or simply find out information can use FRBO.Com, For Rent By Owner,.
Ascertain and find out apartment rentals in Queretaro and Queretaro Mexico home rentals.
Detect and move Lagos De Moreno Mexico houses for rent and rental properties.
We dreamed up, originated, and hatched our page to be classy and fair.
Cuernavaca town home owners, land owners, rental owners, and rental property owners list Cuernavaca homes for rent, rent houses in Cuernavaca Mexico, and bed and breakfast rentals in Cuernavaca Mexico.
Distinguish, ascertain, and explore rent houses Campeche, homes for rent by owner in Campeche Mexico, and condo rentals in Campeche.
Find out, locate, and ferret out condo rentals in Ciudad Acuna Mexico, Ciudad Acuna Mexico home rentals, and rent houses in Ciudad Acuna.
Empty mountain ranch, city ranch, well appointed hacienda, and lakefront home are convenient in the nearest township of Cuernavaca Mexico.
Our website, FRBO.com accommodates dominion, tract, and neighborhood materials, not seldom.
Our for rent by owner website does omit peculiar studio and oceanfront bungalow and haciendas.
You can comb the beach listed properties, resort classifieds, and exotic directories under house rentals Cuernavaca Mexico and vacation rentals in Cuernavaca Mexico.
Open your inspection online tonight, in the morning, or on Tuesday for your home rentals Cuernavaca, apartment rentals Cuernavaca, and holiday rentals in Cuernavaca Mexico.
Learn and recognize vacation homes for rent by owner Reynosa Mexico and condo rentals in Reynosa Mexico.
Cuernavaca Mexico memorandums could assist, further, abet, and expedite your rummage.
Identify, design, and locate apartments for rent in Pachuca Mexico, rental properties in Pachuca Mexico, and Pachuca Mexico rent house.
Globetrotters, better halves, and excursionists look for and study our for rent by owner site, FRBO.com and light upon exclusive vacation home, oceanfront bungalow, ski in/out timeshare, and beach house.
Perceive and identify the quarter and abutting Cuernavaca Mexico turf.
See lakefront classified advertisements, well appointed classified advertisements, hidden directories, and beach ads that property agents and third party agents post on this webpage.
You can learn, devise, and find home rentals in Cuernavaca, apartment rentals Cuernavaca, and real estate rentals in Cuernavaca.
Cuernavaca Mexico township employs many brokers leasing foreclosures, home owners, property agents, and condo owners.
Recruit, employ, and muster this week to begin, inaugurate, lead off, and enter upon on this visit.
Hear and learn Naucalpan Mexico for rent by owner homes and for rent by owner homes in Naucalpan Mexico.
|
|
