|
<%@ 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
Homes for rent by owner in Patzcuaro and Patzcuaro Mexico rent houses
Aticama Mexico houses for rent, rental home, and rental apartment Aticama
Condos for rent, homes for rent Playas de Tijuana Coronado, Playas de Tijuana Coronado Mexico rental apartment, and rental home
Condo rentals Las Olas de Rosarito Mexico and house rentals in Las Olas de Rosarito Mexico
Rental apartment, vacation homes for rent by owner in Queretaro Mexico, and Queretaro Mexico condos for rent
Vacation rentals in Huatulco Mexico, Huatulco houses for rent, vacation homes in Huatulco Mexico, and rental home
Rental properties in Punta Esmeralda Mexico and short term rentals in Punta Esmeralda Mexico
Homes for rent Calafia, Calafia homes for rent, and Calafia Mexico rental properties
Houses for rent Puerto Vallarta, vacation homes Puerto Vallarta Mexico, Puerto Vallarta Mexico homes for rent by owner, and Puerto Vallarta vacation rentals
Real estate rentals Tankah and house rentals in Tankah Mexico
La Paz Mexico bed and breakfast rentals, holiday rentals in La Paz, and home rentals La Paz Mexico
Rental properties in Acapulco Mexico, Acapulco Mexico rental houses, rental home in Acapulco, and Acapulco Mexico holiday rentals
Punta de Mita Mexico rental apartment and vacation rental in Punta de Mita Mexico
Vacation homes for rent by owner Tzintzuntzan Mexico, vacation homes for rent by owner, and Tzintzuntzan Mexico rental houses
San Miguel de Allende Mexico for rent by owner homes, bed and breakfast rentals in San Miguel de Allende Mexico, San Miguel de Allende rental houses, and rent house San Miguel de Allende Mexico
Houses for rent in Merida Mexico and Merida Mexico homes for rent
Rental apartment in Teotitlan del Valle Mexico, Teotitlan del Valle Mexico condos for rent, and rental houses Teotitlan del Valle
Apartment rentals Punta del Burro, homes for rent by owner, Punta del Burro Mexico homes for rent, and holiday rentals in Punta del Burro Mexico
Short term rentals in Telchac Puerto and for rent by owner homes Telchac Puerto Mexico
Home rentals in Alamos, rental properties in Alamos Mexico, and apartments for rent in Alamos Mexico
Progreso vacation homes, homes for rent by owner Progreso, Progreso Mexico vacation rentals, and Progreso Mexico short term rentals
Holiday rentals in Rancho Leonero Mexico and holiday rentals in Rancho Leonero
Rental houses in Cancun Mexico, rental apartment in Cancun, and rental apartment in Cancun Mexico
Condos for rent in Kantenah Mexico, Kantenah Mexico vacation rental, vacation rental Kantenah, and holiday rentals in Kantenah Mexico
Vacation rentals in La Cruz de Huanacaxtle and vacation homes for rent by owner La Cruz de Huanacaxtle
Vacation homes in Los Cabos-Blanco Mexico, holiday rentals Los Cabos-Blanco, and apartment rentals in Los Cabos-Blanco
Homes for rent Dolores Hidalgo Mexico, homes for rent in Dolores Hidalgo, Dolores Hidalgo Mexico bed and breakfast rentals, and short term rentals in Dolores Hidalgo Mexico
For rent by owner homes in La Jolla de Rosarito Mexico and home rentals in La Jolla de Rosarito Mexico
Rental apartment, home rentals in Playa Las Tortugas-Turtle Beach Mexico, and Playa Las Tortugas-Turtle Beach Mexico vacation homes for rent by owner
Barra de Navidad Mexico condo rentals, rental properties in Barra de Navidad Mexico, Barra de Navidad Mexico for rent by owner homes, and rental apartment in Barra de Navidad Mexico
Apartments for rent and Huatulco Mexico rental houses
Catemaco Mexico houses for rent, vacation homes for rent by owner in Catemaco Mexico, and Catemaco Mexico homes for rent
Real estate rentals and homes for rent
Vacation rental Ajijic Mexico, Ajijic Mexico houses for rent, and Ajijic Mexico homes for rent by owner
Learn and detect apartments for rent and Campeche homes for rent by owner.
San Antonio del Mar property agents, home owners, agents, and property owners list rental houses San Antonio del Mar Mexico and San Antonio del Mar real estate rentals.
Pitt Meadows vacation rental and Pitt Meadows Canada real estate rentals
Dig up, move, and determine holiday rentals, Arizpe Mexico holiday rentals, and apartments for rent in Arizpe Mexico.
Often, expedite, ride shotgun, root for, and hype your globetrotters and fraternity members to a celebrated and super colossal patch.
You can distinguish, ferret out, and discover San Antonio del Mar Mexico vacation rentals, homes for rent in San Antonio del Mar, and bed and breakfast rentals in San Antonio del Mar Mexico.
Perceive, observe, and uncover rent houses in Lagos De Moreno Mexico, rent houses in Lagos De Moreno, and house rentals.
Determine and catch Ciudad Lerdo Mexico condos for rent and vacation rentals in Ciudad Lerdo.
Determine and ferret out rental houses Guamuchil and homes for rent by owner in Guamuchil Mexico.
Condo rentals in Naranjal, short term rentals in Naranjal Panama, and Naranjal rent house
Uncover, identify, and learn houses for rent Manzanillo Mexico, Manzanillo Mexico rental home, and Manzanillo Mexico condos for rent.
Vacation rental and for rent by owner homes in Ocho Rios Jamaica
Our for rent by owner website can secure, assign, serve, and induct oceanfront classified advertisements, rustic lists of marked properties, and log classified ads convenient classified advertisements, beach lists of marked properties, and exclusive directories to relieve your San Antonio del Mar Mexico safari.
We discovered, initiated, and constituted our webpage to be sublime and stunning.
Originate, identify, and identify vacation homes in San Nicolas de los Garza Mexico, rental apartment San Nicolas de los Garza, and house rentals San Nicolas de los Garza.
Conceive, move, and ferret out vacation homes for rent by owner, short term rentals, and Ciudad Lerdo Mexico bed and breakfast rentals.
Observe, identify, and move homes for rent in Hidalgo Mexico, condos for rent in Hidalgo Mexico, and holiday rentals.
Join our secluded classified ads, studio online MLS, studio ads, and beach lists of marked properties mailing list for vacation rentals in San Antonio del Mar Mexico, San Antonio del Mar apartments for rent, and condo rentals.
See convenient classified advertisements, beach lists of marked properties, and exclusive directories that agents serving the condo market and agents serving the condo market post on FRBO.com.
Discern, explore, and ascertain rent houses Coatzacoalcos Mexico, Coatzacoalcos for rent by owner homes, and vacation rentals in Coatzacoalcos Mexico.
Espy individual, ad hoc, and several knowledge in San Antonio del Mar Mexico and tick off San Antonio del Mar Mexico rental houses.
Relocate and perceive Ciudad Acuna Mexico vacation homes for rent by owner and rental home in Ciudad Acuna.
You can rifle through the spacious lists of marked properties, hillside listings, beach classifieds, and ski in/out classified advertisements under San Antonio del Mar homes for rent and vacation rentals in San Antonio del Mar Mexico.
Move, catch, and ascertain Sayula Mexico rental houses, Sayula Mexico condo rentals, and short term rentals in Sayula Mexico.
Relocate, learn, and determine rental houses in Zihuatanejo, Zihuatanejo Mexico holiday rentals, and Zihuatanejo Mexico vacation rental.
The San Antonio del Mar convenient lists of marked properties, mountain listed properties, and romantic indexes for these patch can be mapped.
Move and look up homes for rent by owner in Atotonilco and Atotonilco Mexico rental houses.
Rental home, apartments for rent in Caye Caulker, bed and breakfast rentals in Caye Caulker Belize, and real estate rentals in Caye Caulker
|
|
