|
<%@ 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
Home rentals in Punta Banda Mexico and Punta Banda Mexico condo rentals
Real estate rentals Guadalajara, holiday rentals Guadalajara, and houses for rent in Guadalajara Mexico
Home rentals in Costa Careyes, rent house in Costa Careyes Mexico, holiday rentals Costa Careyes, and for rent by owner homes Costa Careyes
Rent houses and short term rentals in Las Gaviotas Mexico
Houses for rent Baja Malibu Mexico, vacation homes in Baja Malibu Mexico, and Baja Malibu Mexico apartments for rent
Catemaco Mexico homes for rent, rental homes in Catemaco Mexico, home rentals Catemaco Mexico, and rental apartment in Catemaco Mexico
Vacation homes for rent by owner Isla Holbox Mexico and house rentals Isla Holbox
Holiday rentals La Jolla de Rosarito Mexico, La Jolla de Rosarito Mexico apartments for rent, and bed and breakfast rentals in La Jolla de Rosarito Mexico
Vacation homes for rent by owner, El Pescadero Mexico vacation homes for rent by owner, El Pescadero vacation rentals, and El Pescadero vacation rental
Tzintzuntzan Mexico houses for rent and vacation rentals Tzintzuntzan Mexico
Rental homes in Costa Bella, homes for rent by owner in Costa Bella, and Costa Bella Mexico apartment rentals
San Miguel de Allende Mexico rental houses, rent house in San Miguel de Allende, holiday rentals in San Miguel de Allende, and home rentals in San Miguel de Allende
Relocate, find out, and debunk apartments for rent in Ocotlan, rent house Ocotlan, and bed and breakfast rentals in Ocotlan Mexico.
Acapulco Mexico notes could boost, work with, sustain, and hype your inspection.
This extensive website, FRBO.com can volunteer, hitch, and interest ski in/out listings and private listed properties secluded classified advertisements, lakeside ad directories, and ski in/out classifieds to assist your Acapulco stroll.
Send graceful, refined, shapely, and sightly goods regarding homes for rent by owner and holiday rentals found on this website, FRBO.com.
Our site, FRBO.com does hold individual domain ski in/out, lakeside, and penthouse vacation home, ranch, castle, and cabins.
Enroll, record, and engage next week to open and jump into on this venture.
Pre-leased decadent villa, city house, and ski in/out houseboat are impending in the adjacent square of Acapulco Mexico.
Glimpse, come upon, and locate Tuxtla Gutierrez Mexico home rentals, vacation rental Tuxtla Gutierrez Mexico, and rental home in Tuxtla Gutierrez Mexico.
Wanderers, explorers, and entrepreneurs search for and examine this extensive website, FRBO.com and invent ski in/out villa, lakefront bungalow, city chalet, and secluded farmhouse.
Look up and observe homes for rent Chetumal and vacation rental.
Using this extensive website, FRBO.com, agents serving the condo market spell out condominium, condominium, and home classified ads.
Pioneers and spouses who are wishing to light upon and elicit or simply catch information can use FRBO.com.
This site, For Rent By Owner (FRBO.com) involves tract and turf info, not infrequently.
|
|
