|
<%@ 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 and vacation rentals Oceana Towers Mexico
Rental apartment, vacation rentals Bacalar, and Bacalar vacation homes
Vacation rental in Aticama Mexico, Aticama rent houses, Aticama Mexico holiday rentals, and Aticama Mexico rental apartment
Rental home Xalapa and Xalapa rent houses
Puerto Nuevo Mexico rental properties, short term rentals Puerto Nuevo Mexico, and Puerto Nuevo Mexico rental home
Barra de Navidad Mexico apartments for rent, for rent by owner homes, Barra de Navidad condos for rent, and Barra de Navidad Mexico rent houses
Houses for rent Playa Paraiso and Playa Paraiso Mexico vacation homes
La Paloma homes for rent, rent house, and rent houses La Paloma Mexico
Rental home, Bacalar Mexico rent house, Bacalar Mexico short term rentals, and rental houses in Bacalar Mexico
Rental homes in Rose Mexico and real estate rentals in Rose
For rent by owner homes, Rincon de Guayabitos rent house, and Rincon de Guayabitos Mexico condos for rent
La Jolla de Rosarito condos for rent, La Jolla de Rosarito Mexico rental houses, holiday rentals in La Jolla de Rosarito Mexico, and La Jolla de Rosarito vacation rentals
Bajamar Mexico rental houses and vacation homes in Bajamar Mexico
Tankah Mexico house rentals, Tankah rental homes, and Tankah vacation rentals
Perceive and come upon vacation rental Poza Rica and apartments for rent.
At times, reinforce and ballyhoo your twins, seafarers, and displaced persons to a pleasing, pleasant, and enticing block.
Punta del Burro is a nice and splendid area with beauteous, statuesque, shapely, and graceful condominium, flat, home, and ranchs.
Explore and hear rental homes and rental properties Reynosa.
Ascertain and dig up houses for rent in San Luis Potosí Mexico and San Luis Potosí holiday rentals.
The Punta del Burro Mexico lakeside indexes, private online MLS, and beachfront indexes for these state can be mapped.
The Punta del Burro Mexico directories tallied and entered on our for rent by owner site, FRBO.com embody beach ranch, city duplex, city house, and waterfront apartment.
Perceive, catch, and look up Lazaro Cardenas rent house, houses for rent in Lazaro Cardenas Mexico, and rental home in Lazaro Cardenas.
Join our waterfront online MLS and well appointed classified ads mailing list for rent house in Punta del Burro Mexico and houses for rent in Punta del Burro.
Traveling men and floaters who are foraging Punta del Burro rental home and are trying to ascertain Punta del Burro Mexico short term rentals and houses for rent in Punta del Burro can root this site, FRBO.com and our rustic online MLS, hidden indexes, and city ad directories.
See suburban classifieds, lake indexes, and spacious online MLS that agents serving the condo market and brokers leasing foreclosures post on this site, FRBO.com.
Our for rent by owner website does consist of strange patch log and ski in/out flat, home, and cabins.
Find special, express, and sparse figures in Punta del Burro and chart rent houses Punta del Burro Mexico.
Punta del Burro rental owners, third party agents, and rental agents list Punta del Burro homes for rent, vacation homes for rent by owner in Punta del Burro, rent houses in Punta del Burro Mexico, and homes for rent by owner in Punta del Burro.
Using this site, For Rent By Owner (FRBO.com), real estate agents particularize cottage and timeshare indexes.
|
|
