|
<%@ 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" %>
|
Brazil Rental Links
Trancoso homes for rent and rental properties Trancoso
Apartment rentals, apartments for rent Pantano do Sul, and rental apartment
Home rentals, rental houses in Itacare, vacation rentals in Itacare, and Itacare rent house
Rent house and rent houses Garopaba
House rentals in Recife Brazil, Recife homes for rent by owner, and homes for rent by owner in Recife
For rent by owner homes Buzios Brazil, Buzios rental apartment, condos for rent in Buzios Brazil, and Buzios rent house
Holiday rentals in Recife Brazil and Recife rental properties
Rental home in Recife Brazil, Recife condo rentals, and rental houses in Recife
Real estate rentals in Buzios Brazil, rent house in Buzios Brazil, vacation rental in Buzios Brazil, and rental apartment in Buzios
Apartments for rent Vitoria and rental homes in Vitoria Brazil
Rio de Janeiro vacation homes for rent by owner, rental apartment Rio de Janeiro Brazil, and home rentals Rio de Janeiro
Natal Brazil apartment rentals, rent houses Natal, homes for rent by owner in Natal Brazil, and Natal Brazil rent houses
Ilhabela Brazil rental apartment and short term rentals
Condos for rent in Maresias Brazil, Maresias Brazil vacation rentals, and houses for rent Maresias Brazil
Vacation rentals in Jacuma, house rentals in Jacuma Brazil, bed and breakfast rentals in Jacuma, and Jacuma Brazil rental apartment
Short term rentals Paraty and vacation rental in Paraty Brazil
Angra Dos Reis short term rentals, house rentals, and Angra Dos Reis Brazil rental home
Recife Brazil short term rentals, apartments for rent Recife, Recife Brazil house rentals, and Recife Brazil vacation rental
Buzios Brazil rental houses and vacation rental in Buzios Brazil
Houses for rent in Ilhabela Brazil, Ilhabela Brazil rent house, and holiday rentals Ilhabela Brazil
Ilhabela Brazil rental home, for rent by owner homes Ilhabela Brazil, rental houses Ilhabela, and vacation rentals Ilhabela Brazil
Real estate rentals and house rentals Recife
For rent by owner homes, Pantano do Sul rental homes, and apartments for rent Pantano do Sul Brazil
Apartment rentals in Angra Dos Reis Brazil, Angra Dos Reis Brazil houses for rent, apartments for rent in Angra Dos Reis Brazil, and short term rentals Angra Dos Reis Brazil
Rental home Recife and houses for rent Recife
Paraty house rentals, Paraty Brazil vacation rentals, and Paraty apartments for rent
Vacation rental in Maresias Brazil, apartment rentals in Maresias, rental home in Maresias Brazil, and Maresias Brazil rental houses
Apartment rentals Vitoria and short term rentals in Vitoria Brazil
Notice, determine, and look up real estate rentals in Divinópolis Brazil, Divinópolis Brazil vacation rentals, and house rentals in Divinópolis.
Using this site, For Rent By Owner (FRBO.com), town home owners catalogue villa, house, farmhouse, and farmhouse classified advertisements.
Dig up, come upon, and distinguish short term rentals Cascavel, rental houses Cascavel, and Cascavel Brazil rental houses.
For Rent By Owner does eliminate distinctive parcel beach, studio, rustic, and beach ranch, duplex, cabin, and houses.
You can frisk the beachfront listed properties, beach advertisements, well appointed directories, and waterfront advertisements under short term rentals in Jacuma Brazil and condo rentals in Jacuma.
Originate and notice apartments for rent and condos for rent.
Rental apartment Caburga Chile, condos for rent Caburga Chile, and vacation rentals
Determine and light upon house rentals in Três Lagoas and houses for rent Três Lagoas.
Jacuma agents serving the condo market, land owners, and rental agents list vacation homes for rent by owner Jacuma Brazil, rental properties in Jacuma, Jacuma rental home, and vacation rentals in Jacuma.
The Jacuma Brazil penthouse advertisements, romantic advertisements, studio ads, and hidden classifieds for these can be mapped.
Jacuma Brazil domain employs many property owners and property brokers.
Adventurers and journeyers quest and hunt this site, FRBO.com and move city lodge and hillside ranch.
Jacuma Brazil is a excellent, enticing, and symmetrical state with delightful and alluring apartment, lodge, vacation home, and homes.
Vacation rentals, home rentals Bariloche Argentina, holiday rentals Bariloche Argentina, and vacation homes in Bariloche Argentina
Relocate, locate, and come upon Porto Velho homes for rent, bed and breakfast rentals in Porto Velho Brazil, and vacation rental in Porto Velho Brazil.
Jacuma poop sheet could do for and run interference your wild-goose chase.
Distinguish, find, and identify apartments for rent, Campo Grande Brazil home rentals, and vacation homes in Campo Grande Brazil.
See hidden online MLS, decadent classified advertisements, exclusive classified advertisements, and hillside indexes that agents and real estate investors post on this site, FRBO.com.
Our for rent by owner site, FRBO.com can record and sign on resort indexes, waterfront listings, and beach online MLS hillside ads, spacious listed properties, lake listings, and beachfront listed properties to assist your Jacuma Brazil migration.
For rent by owner homes in Puerto la Cruz, Puerto la Cruz Venezuela rental houses, condos for rent in Puerto la Cruz, and home rentals
|
|
