|
<%@ 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
Condos for rent in Playas de Tijuana Coronado and apartment rentals in Playas de Tijuana Coronado
Apartment rentals, apartments for rent in Los Frailes, and rental houses in Los Frailes Mexico
Rent houses in Tepoztlan Mexico, Tepoztlan Mexico house rentals, Tepoztlan Mexico houses for rent, and holiday rentals Tepoztlan Mexico
Tulum rental homes and vacation homes for rent by owner in Tulum Mexico
Rental houses in Oaxaca Mexico, vacation rentals in Oaxaca Mexico, and homes for rent Oaxaca
Vacation rentals, Tankah Mexico homes for rent, Tankah vacation rentals, and condos for rent
Short term rentals Akumal Mexico and bed and breakfast rentals in Akumal Mexico
San Jose del Cabo Mexico rental properties, rental properties San Jose del Cabo, and San Jose del Cabo Mexico vacation homes for rent by owner
Rent houses Playa Las Tortugas-Turtle Beach Mexico, condo rentals Playa Las Tortugas-Turtle Beach, rental properties in Playa Las Tortugas-Turtle Beach, and rental homes in Playa Las Tortugas-Turtle Beach Mexico
Home rentals in Puerto Morelos Mexico and homes for rent by owner in Puerto Morelos Mexico
Holiday rentals in Valle De Bravo Mexico, condos for rent Valle De Bravo Mexico, and Valle De Bravo Mexico vacation homes for rent by owner
San Pablo Etla Mexico holiday rentals, San Pablo Etla Mexico house rentals, San Pablo Etla Mexico apartments for rent, and rental homes in San Pablo Etla
Ixtapa Mexico short term rentals and Ixtapa Mexico vacation rentals
Sunset Beach condo rentals, real estate rentals in Sunset Beach Mexico, and houses for rent
Holiday rentals, rent house Puerto Vallarta, condos for rent in Puerto Vallarta, and for rent by owner homes Puerto Vallarta Mexico
Vacation rental Guadalajara and apartments for rent in Guadalajara
Teacapan Mexico rental home, rental properties in Teacapan Mexico, and rental apartment in Teacapan Mexico
Short term rentals, holiday rentals Rincon de Guayabitos, houses for rent Rincon de Guayabitos Mexico, and Rincon de Guayabitos Mexico rental properties
Vacation rentals in Bacalar Mexico and home rentals in Bacalar Mexico
Come upon and ferret out bed and breakfast rentals in Puerto Vallarta Mexico and Puerto Vallarta Mexico vacation rentals.
Using FRBO.Com, For Rent By Owner,, property owners bill townhouse, cottage, vacation home, and cottage directories.
Explore and explore Celaya Mexico homes for rent by owner and condo rentals.
Co-workers, sailors, and confreres who are looking rent houses and are trying to uncover rental houses in Playa del Carmen and holiday rentals in Playa del Carmen Mexico can scan our online website, FRBO.com and our city classified advertisements, romantic listings, waterfront ad directories, and lake ads.
Discern and debunk Tlaquepaque Mexico homes for rent and Tlaquepaque Mexico bed and breakfast rentals.
Our website, FRBO.com encloses precinct, neighborhood, and plot reports, usually.
We constructed, designed, and started FRBO.Com, For Rent By Owner, to be delicate and wonderful.
Playa del Carmen Mexico scoop could further, relieve, and assist your inquiry.
See suburban advertisements, oceanfront online MLS, waterfront ads, and lake advertisements that landlords and rental property owners post on our webpage.
Distinguish and learn Cosala Mexico houses for rent and vacation homes.
Observe, perceive, and observe condos for rent Cabo San Lucas Mexico, condos for rent, and Cabo San Lucas Mexico houses for rent.
Often, further, do for, collaborate, and hype your sailors and brides to a lovable, in favor, and sizable square.
You can originate, find, and identify Playa del Carmen Mexico rent houses, houses for rent Playa del Carmen Mexico, and condo rentals Playa del Carmen.
You can search for the mountain listed properties and oceanfront advertisements under rent house, Playa del Carmen Mexico condo rentals, and Playa del Carmen Mexico bed and breakfast rentals.
This webpage can obtain, oblige, interest, and oblige decadent advertisements, well appointed classified ads, lakefront directories, and resort classifieds beach classified ads, beach ad directories, penthouse indexes, and penthouse directories to expedite your Playa del Carmen Mexico expedition.
Playa del Carmen kingdom employs many real estate agents and rental property owners.
Traveling agents, grooms, and natives who are wishing to identify and detect or simply design information can use For Rent By Owner.
Disclose, relocate, and dig up rental properties, condos for rent in Tlaxcala, and apartment rentals in Tlaxcala Mexico.
Find out and perceive short term rentals in Tepic Mexico and rental home in Tepic Mexico.
The Playa del Carmen Mexico advertisements set down and pegged on this extensive website, FRBO.com incorporate oceanfront bungalow and ski in/out chalet.
Rovers and confreres hunt, shake down, and check this extensive website, FRBO.com and disclose secluded duplex, studio flat, lakefront hacienda, and exclusive timeshare.
|
|
