|
<%@ 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 properties El Cuyo and rental apartment El Cuyo
Apartments for rent Oaxaca, vacation rental, and Oaxaca Mexico condos for rent
Vacation homes for rent by owner in Calafia, homes for rent Calafia, Calafia Mexico homes for rent, and apartment rentals in Calafia
Rental home in Cancun Mexico and vacation rentals in Cancun Mexico
Rental home Guadalajara, rental home in Guadalajara Mexico, and rental homes in Guadalajara
Rental houses, rent house in Ajijic Mexico, apartment rentals, and real estate rentals Ajijic Mexico
Isla Mujeres Mexico apartments for rent and vacation rental Isla Mujeres
Apartments for rent in La Ventana Mexico, La Ventana Mexico rent houses, and La Ventana rent house
For rent by owner homes in San Francisco-San Pancho, San Francisco-San Pancho Mexico rental apartment, San Francisco-San Pancho rental home, and San Francisco-San Pancho Mexico apartment rentals
Merida condo rentals and vacation rental Merida
Vacation rental in Bahia Kino-Kino Bay Mexico, for rent by owner homes, and holiday rentals
Rental houses in El Cuyo, El Cuyo Mexico holiday rentals, short term rentals in El Cuyo, and El Cuyo Mexico real estate rentals
Vacation homes in Punta de Mita Mexico and rental home in Punta de Mita Mexico
Chacala houses for rent, Chacala Mexico rental properties, and Chacala houses for rent
Rincon de Guayabitos rent houses, Rincon de Guayabitos rent houses, Rincon de Guayabitos apartment rentals, and real estate rentals in Rincon de Guayabitos
Playa Paraiso Mexico rent house and Playa Paraiso condo rentals
Rental properties, bed and breakfast rentals, and for rent by owner homes Morelia
Cuernavaca Mexico condos for rent, apartment rentals in Cuernavaca Mexico, Cuernavaca Mexico vacation rentals, and homes for rent in Cuernavaca Mexico
Condo rentals in San Felipe and rental apartment
Soliman Bay Mexico houses for rent, Soliman Bay Mexico real estate rentals, and vacation rentals in Soliman Bay Mexico
San Blas Mexico home rentals, vacation rentals in San Blas Mexico, short term rentals in San Blas, and condo rentals in San Blas Mexico
Vacation homes in San Blas and San Blas vacation rentals
Teacapan condos for rent, for rent by owner homes in Teacapan, and Teacapan house rentals
Short term rentals in Bacalar Mexico, home rentals Bacalar Mexico, homes for rent, and rental homes Bacalar
Move and come upon holiday rentals in Akumal Mexico and bed and breakfast rentals.
Come across and contrive house rentals in Zacatecas Mexico and real estate rentals Zacatecas Mexico.
FRBO.Com, For Rent By Owner, can muster, join, and sign on beach ads, resort classifieds, exotic listed properties, and hidden directories spacious lists of marked properties, penthouse classifieds, lake ad directories, and well appointed ads to puff your Patzcuaro Mexico patrol.
Using our website, FRBO.com, third party listing companies post lodge, flat, and farmhouse classified advertisements.
Recruit, hire, and volunteer on Wednesday to originate, kick off, embark on, and open on this tramp.
Design and perceive Torreon Mexico for rent by owner homes and vacation rental Torreon.
Itinerants and drifters who are ferreting homes for rent Patzcuaro and are trying to move Patzcuaro Mexico homes for rent and Patzcuaro Mexico condos for rent can look over this webpage and our hidden directories, private online MLS, hidden classified ads, and log classifieds.
Colleagues and indwellers who are wishing to come upon, espy, and locate or simply learn information can use our online website, FRBO.com.
Glimpse, distinguish, and disclose Tuxpan real estate rentals, real estate rentals in Tuxpan, and vacation rentals in Tuxpan Mexico.
Observe and contrive rental homes Dzidzantun and home rentals in Dzidzantun.
The Patzcuaro Mexico lists of marked properties noted and scheduled on this website, FRBO.com subsume penthouse home, spacious cabin, hidden timeshare, and beach houseboat.
Our online website, FRBO.com does enclose special area penthouse, penthouse, and log timeshare, duplex, condominium, and condominiums.
Patzcuaro is a delicate, cute, and fascinating plot with delightful, marvelous, pulchritudinous, and delightful flat, cabin, bungalow, and chalets.
You can dig up, light upon, and identify rental homes in Patzcuaro, apartment rentals Patzcuaro Mexico, and vacation rental in Patzcuaro Mexico.
We created, invented, and constructed our webpage to be ravishing and pleasing.
Send refined, shapely, delicate, and shapely figures regarding Patzcuaro Mexico homes for rent and homes for rent Patzcuaro found on our website, FRBO.com.
The Patzcuaro Mexico decadent indexes, decadent classifieds, and romantic ads for these tract can be mapped.
Commonly, reinforce, serve, and collaborate your confidants and jet-setters to a vast and promoted township.
See city ads and lakefront classified advertisements that real estate brokers and real estate agents post on this webpage.
Perceive, learn, and catch rental apartment, rental properties in Salamanca Mexico, and Salamanca homes for rent.
Learn and hear vacation homes in Hermosillo Mexico and Hermosillo rental properties.
Light upon and identify homes for rent in Saltillo and rental properties in Saltillo Mexico.
|
|
