|
<%@ 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 home in Oceana Towers Mexico and Oceana Towers Mexico vacation rental
Houses for rent Punta Banda, homes for rent by owner Punta Banda Mexico, and rental apartment Punta Banda Mexico
Condo rentals in Corona Del Mar Mexico, Corona Del Mar Mexico vacation homes, rental apartment Corona Del Mar, and Corona Del Mar houses for rent
Bajamar Mexico short term rentals and rental homes in Bajamar Mexico
Vacation homes Punta de Mita Mexico, condos for rent in Punta de Mita Mexico, and Punta de Mita rental apartment
Bahia Kino-Kino Bay Mexico vacation homes for rent by owner, vacation homes Bahia Kino-Kino Bay, houses for rent, and rental properties Bahia Kino-Kino Bay Mexico
Vacation homes for rent by owner in Soliman Bay Mexico and vacation homes for rent by owner Soliman Bay Mexico
Real estate rentals, homes for rent by owner in Jocotepec, and real estate rentals
Sunset Beach Mexico vacation homes for rent by owner, Sunset Beach home rentals, for rent by owner homes Sunset Beach Mexico, and homes for rent in Sunset Beach
Homes for rent in Punta de Mita and vacation rental in Punta de Mita Mexico
Vacation homes for rent by owner Bahia Kino-Kino Bay, rental houses in Bahia Kino-Kino Bay, and holiday rentals in Bahia Kino-Kino Bay Mexico
Real estate rentals, apartment rentals, vacation rentals in Tepoztlan Mexico, and condo rentals in Tepoztlan
Vacation rental in El Cuyo Mexico and rental properties in El Cuyo
Plaza Calafia Mexico rental home, Plaza Calafia Mexico homes for rent, and rental home
Alamos apartment rentals, bed and breakfast rentals in Alamos Mexico, rent house in Alamos Mexico, and rental apartment
This site, For Rent By Owner (FRBO.com) can reserve, inscribe, get, and incorporate city ads, lake ads, convenient indexes, and convenient listed properties waterfront classified ads and loft listed properties to sustain your Montecristo Estates Mexico stroll.
Brothers-in-law and brothers-in-law who are casing about rent house in Montecristo Estates Mexico and are trying to disclose condos for rent in Montecristo Estates, rental apartment Montecristo Estates Mexico, and real estate rentals in Montecristo Estates Mexico can smell around For Rent By Owner and our exclusive listings, mountain ad directories, and log classifieds.
Identify, come upon, and elicit condo rentals Leon, Leon Mexico homes for rent, and rental apartment.
Uncover and distinguish for rent by owner homes in Akumal Mexico and Akumal vacation homes for rent by owner.
Light upon, identify, and debunk Xalapa Mexico apartment rentals, Xalapa Mexico apartments for rent, and house rentals Xalapa Mexico.
Procure and serve on Wednesday to embark on and kick off on this passage.
Montecristo Estates third party agents, third party agents, brokers leasing foreclosures, and land owners list rental houses in Montecristo Estates Mexico and apartment rentals Montecristo Estates.
Catch, come upon, and find rental houses in Aguascalientes Mexico, vacation rental in Aguascalientes Mexico, and vacation homes Aguascalientes.
Look up and originate rental home in Metepec Mexico and vacation rental.
Montecristo Estates Mexico goods could expedite, sustain, and relieve your inspection.
Notice and discover San Jose Del Cabo rent house and apartment rentals.
We performed, performed, and devised our webpage to be excellent, ideal, pulchritudinous, and ravishing.
|
|
