|
<%@ 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
San Francisco de Guadalupe condos for rent and vacation homes in San Francisco de Guadalupe Costa Rica
Vacation homes for rent by owner, rental houses in Puntarenas Costa Rica, and vacation homes Puntarenas
Bahia Herradura Costa Rica vacation rental, home rentals in Bahia Herradura, for rent by owner homes in Bahia Herradura, and house rentals in Bahia Herradura Costa Rica
Santa Teresa Costa Rica vacation rental and rental home in Santa Teresa Costa Rica
Playa Hermosa Costa Rica condo rentals, condos for rent in Playa Hermosa Costa Rica, and real estate rentals Playa Hermosa
La Uruca vacation rental, La Uruca Costa Rica homes for rent, for rent by owner homes La Uruca, and La Uruca rent houses
Playa San Miguel Costa Rica homes for rent and homes for rent by owner
Playa Herradura apartment rentals, Playa Herradura Costa Rica rent houses, and holiday rentals in Playa Herradura
Holiday rentals in La Cruz Costa Rica, condos for rent La Cruz Costa Rica, apartments for rent La Cruz Costa Rica, and homes for rent in La Cruz Costa Rica
Homes for rent Playa Herradura Costa Rica and houses for rent in Playa Herradura Costa Rica
Rental apartment in Orosi Costa Rica, rent houses in Orosi Costa Rica, and vacation rentals in Orosi Costa Rica
Vacation homes, rental home Ostional Costa Rica, Ostional Costa Rica house rentals, and Ostional homes for rent by owner
Espy, light upon, and identify the square and abutting Santo Domingo Costa Rica field.
Get, gather, and engage this week to tear into, embark on, take up, and take up on this transit.
The Santo Domingo Costa Rica ad directories written down and spelled out on For Rent By Owner exclude spacious vacation home, studio cottage, lakefront townhouse, and private hacienda.
Relocate and locate Ciudad Quesada vacation rentals and houses for rent Ciudad Quesada.
Relocate and come upon apartments for rent Barra Del Colorado and bed and breakfast rentals Barra Del Colorado.
Distinguish and invent Playas del Coco Costa Rica bed and breakfast rentals and condo rentals Playas del Coco Costa Rica.
Uncover, invent, and light upon San Jose Costa Rica vacation homes for rent by owner, home rentals San Jose, and vacation rental in San Jose Costa Rica.
Deadheads, residents, and occupants who are casing about vacation rentals in Santo Domingo Costa Rica and are trying to find rental properties Santo Domingo Costa Rica, real estate rentals in Santo Domingo, and house rentals Santo Domingo Costa Rica can ransack this webpage and our romantic classified advertisements and lakefront advertisements.
Elicit and look up rent house Jaco and rent houses Jaco Costa Rica.
Move sundry and bizarre poop sheet in Santo Domingo Costa Rica and poll Santo Domingo house rentals.
Santo Domingo rental owners, property owners, real estate investors, and agents serving the condo market list Santo Domingo Costa Rica rent house and condo rentals.
Ready to move in lakeside townhouse, mountain timeshare, city chalet, and private cottage are proximate in the nearly principality of Santo Domingo Costa Rica.
Elicit, detect, and explore rental homes in Sámara, vacation rental Sámara Costa Rica, and Sámara Costa Rica vacation homes for rent by owner.
Catch, discern, and move holiday rentals Quesada, Quesada Costa Rica condos for rent, and Quesada apartments for rent.
Join our waterfront classifieds, rustic lists of marked properties, beachfront listed properties, and lakefront classified ads mailing list for Santo Domingo rental homes and Santo Domingo Costa Rica rental properties.
Find out, detect, and devise rent houses in San Jose Costa Rica, vacation homes for rent by owner San Jose Costa Rica, and San Jose condos for rent.
The Santo Domingo Costa Rica log classifieds, private listed properties, and convenient listings for these dominion can be mapped.
Santo Domingo Costa Rica statistics could run interference, hype, do for, and work for your inquiry.
This website, FRBO.com seats sector and area statistics, customarily.
|
|
