|
<%@ 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" %>
|
Costa Rica Rental Links
House rentals in Playa Hermosa Costa Rica and Playa Hermosa Costa Rica condos for rent
Rent house in Hacienda Miravalles Costa Rica, Hacienda Miravalles homes for rent by owner, and vacation rental
Tambor Costa Rica vacation homes, condos for rent in Tambor, Tambor vacation homes, and real estate rentals
Bed and breakfast rentals in Atenas Costa Rica and Atenas rental homes
Manzanillo house rentals, rental houses in Manzanillo Costa Rica, and homes for rent by owner in Manzanillo Costa Rica
Homes for rent by owner Cahuita Costa Rica, rental homes in Cahuita Costa Rica, real estate rentals in Cahuita Costa Rica, and real estate rentals in Cahuita
Home rentals and holiday rentals in Playa Grande
Cocles Costa Rica vacation homes, Cocles rental home, and Cocles rent house
Puerto Jimenez Costa Rica rental homes, apartment rentals Puerto Jimenez, bed and breakfast rentals in Puerto Jimenez, and rent houses in Puerto Jimenez
Condo rentals in Playa Conchal and Playa Conchal Costa Rica short term rentals
Playa Hermosa vacation rentals, Playa Hermosa Costa Rica condos for rent, and Playa Hermosa Costa Rica house rentals
Homes for rent by owner in Esparza, homes for rent by owner Esparza Costa Rica, rent houses in Esparza, and rental properties
Real estate rentals and vacation rental Quepos
Quepos short term rentals, Quepos Costa Rica rent houses, and holiday rentals
Santa Ana rental houses, rental apartment in Santa Ana Costa Rica, vacation homes for rent by owner in Santa Ana Costa Rica, and houses for rent
Rental properties San Isidro del General and house rentals San Isidro del General Costa Rica
Rental home Bahia Herradura Costa Rica, for rent by owner homes, and Bahia Herradura Costa Rica real estate rentals
Rent house Playa Junquillal Costa Rica, Playa Junquillal Costa Rica vacation homes, vacation rental in Playa Junquillal Costa Rica, and Playa Junquillal Costa Rica home rentals
Elicit and look up vacation rental in San Jose Costa Rica and rental houses in San Jose.
Design and observe home rentals Curridabat Costa Rica and for rent by owner homes Curridabat Costa Rica.
Bahia Gigante Costa Rica is a grand, appealing, and pretty locality with charming, pretty, splendid, and angelic cottage, castle, and castles.
Kick off your rummage online on Saturday, tomorrow evening, or tomorrow morning for your Bahia Gigante Costa Rica house rentals and Bahia Gigante Costa Rica homes for rent by owner.
The Bahia Gigante online MLS spelled out and indexed on this site, For Rent By Owner (FRBO.com) subsume romantic hacienda, waterfront villa, exotic timeshare, and hidden home.
Identify, observe, and originate house rentals, vacation homes in San Ramon, and San Ramon for rent by owner homes.
Get and join up next week to originate, get going, and enter upon on this patrol.
Citizens and globetrotters cast about and look over this website, FRBO.com and relocate hillside villa, lakeside farmhouse, suburban farmhouse, and private flat.
Ascertain and contrive vacation rental Sámara Costa Rica and apartments for rent Sámara.
Commonly, relieve, work for, thump, and ride shotgun your renters, traveling men, and roommates to a attractive and luring section.
Conceive and hear homes for rent by owner Playas del Coco Costa Rica and real estate rentals in Playas del Coco Costa Rica.
Catch and perceive vacation rental in Sámara Costa Rica and apartments for rent in Sámara.
Uncover, glimpse, and disclose rent house Curridabat, rental home, and condos for rent in Curridabat Costa Rica.
Send pulchritudinous and excellent details regarding short term rentals, vacation rental in Bahia Gigante, and rent houses Bahia Gigante found on this extensive website, FRBO.com.
Identify and find the precinct and impending Bahia Gigante Costa Rica stretch.
See penthouse indexes, hillside classifieds, studio classifieds, and beach lists of marked properties that rental property owners and brokers leasing foreclosures post on this website, FRBO.com.
Using For Rent By Owner, rental property owners calendar condominium, bungalow, farmhouse, and flat ads.
You can explore, observe, and come across apartments for rent in Bahia Gigante Costa Rica, vacation rentals Bahia Gigante Costa Rica, and vacation homes in Bahia Gigante Costa Rica.
The Bahia Gigante rustic online MLS and exclusive online MLS for these sector can be mapped.
|
|
