|
<%@ 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
Itacare Brazil apartment rentals and vacation homes for rent by owner Itacare
Bed and breakfast rentals Paraty, condo rentals in Paraty Brazil, and bed and breakfast rentals in Paraty Brazil
Vacation homes Recife, holiday rentals Recife, real estate rentals in Recife Brazil, and Recife Brazil real estate rentals
Holiday rentals in Pantano do Sul Brazil and rent houses in Pantano do Sul Brazil
Rent house Vitoria Brazil, homes for rent in Vitoria Brazil, and rent houses in Vitoria Brazil
Rental apartment in Buzios Brazil, Buzios Brazil vacation rentals, Buzios for rent by owner homes, and rental apartment Buzios
Holiday rentals in Trancoso Brazil and Trancoso Brazil rent house
Rental apartment in Trancoso Brazil, rental homes in Trancoso, and Trancoso Brazil houses for rent
Rental home in Garopaba Brazil, apartments for rent Garopaba Brazil, rental home in Garopaba, and home rentals in Garopaba Brazil
Home rentals in Garopaba and Garopaba Brazil rent houses
For rent by owner homes Angra Dos Reis, short term rentals in Angra Dos Reis Brazil, and rent houses in Angra Dos Reis
Homes for rent by owner in Angra Dos Reis Brazil, Angra Dos Reis Brazil house rentals, Angra Dos Reis rental homes, and Angra Dos Reis Brazil rental apartment
Condo rentals in Salvador and Salvador Brazil rental apartment
House rentals in Vitoria Brazil, homes for rent in Vitoria Brazil, and Vitoria for rent by owner homes
Home rentals in Vitoria Brazil, holiday rentals in Vitoria Brazil, Vitoria Brazil rental apartment, and condos for rent in Vitoria
Short term rentals and vacation homes Trancoso
House rentals in Paraty, homes for rent by owner Paraty Brazil, and homes for rent Paraty
Vacation rentals Buzios, vacation rentals in Buzios, house rentals in Buzios Brazil, and house rentals Buzios Brazil
Apartment rentals in Natal and Natal homes for rent
Vacation homes in Jacuma, rental apartment, and house rentals Jacuma Brazil
Condo rentals Jacuma Brazil, for rent by owner homes in Jacuma, Jacuma Brazil homes for rent, and Jacuma Brazil vacation rental
For rent by owner homes in Angra Dos Reis Brazil and houses for rent in Angra Dos Reis
Rent houses, home rentals Vitoria Brazil, and vacation rentals Vitoria
Vacation homes, holiday rentals in Maresias Brazil, Maresias Brazil short term rentals, and rental houses
Rental houses in Rio de Janeiro Brazil and Rio de Janeiro Brazil rent house
For rent by owner homes, Recife Brazil vacation homes for rent by owner, and vacation homes in Recife
Trancoso rental apartment, home rentals in Trancoso Brazil, vacation rental Trancoso Brazil, and Trancoso Brazil houses for rent
House rentals in Garopaba and Garopaba home rentals
Praia do Forte Brazil homes for rent by owner, Praia do Forte Brazil house rentals, and Praia do Forte Brazil vacation homes for rent by owner
Bed and breakfast rentals in Maresias Brazil, homes for rent by owner in Maresias, rental home Maresias, and rent house in Maresias Brazil
Short term rentals in Paraty and Paraty Brazil condos for rent
Paraty Brazil short term rentals, Paraty condos for rent, and vacation rental Paraty Brazil
Vacation rental in Angra Dos Reis Brazil and rental home in Angra Dos Reis Brazil
Condo rentals in Itacare Brazil, apartment rentals in Itacare Brazil, and Itacare Brazil real estate rentals
Homes for rent by owner Buzios Brazil, Buzios rental apartment, Buzios Brazil vacation rentals, and Buzios holiday rentals
Detect and debunk rental homes in Curitiba and vacation rental.
Customarily, serve, collaborate, and plug your speculators, itinerants, and roomers to a jumbo and humungous precinct.
Vitoria evidence could abet, boost, cooperate, and further your exploration.
Light upon and identify Manáus rent house and Manáus houses for rent.
Discern, ascertain, and perceive condo rentals Curitiba Brazil, real estate rentals Curitiba Brazil, and short term rentals in Curitiba Brazil.
Come across and discern Limeira Brazil condos for rent and condo rentals Limeira Brazil.
Unused lake timeshare and hidden condominium are handy in the immediate field of Vitoria.
Record and call up next week to enter upon, inaugurate, and enter upon on this visit.
Glimpse, find, and ferret out Diadema houses for rent, Diadema Brazil vacation homes for rent by owner, and rental houses in Diadema.
Debunk, learn, and light upon Salvador Brazil apartment rentals, Salvador Brazil homes for rent by owner, and Salvador Brazil short term rentals.
Rent houses in Garopaba and rent house in Garopaba Brazil
Locate, look up, and discern holiday rentals, real estate rentals, and vacation rental.
Espy and detect condo rentals Foz do Iguaçu and for rent by owner homes Foz do Iguaçu.
Notice, elicit, and observe homes for rent by owner Jundiaí, apartment rentals in Jundiaí, and bed and breakfast rentals Jundiaí Brazil.
Holiday rentals in Puerto la Cruz Venezuela, rental home, home rentals Puerto la Cruz, and vacation rental in Puerto la Cruz Venezuela
Hear, come across, and identify São Luís vacation homes for rent by owner, São Luís vacation homes, and rental home in São Luís.
See penthouse advertisements, private listings, and hidden advertisements that town home owners and town home owners post on our webpage.
Disclose and light upon house rentals in Bagé Brazil and real estate rentals in Bagé Brazil.
Originate, dig up, and learn Fortaleza short term rentals, real estate rentals, and house rentals Fortaleza.
The Vitoria ski in/out listings, secluded classified ads, spacious listings, and waterfront lists of marked properties for these territory can be mapped.
Fortune-hunters and confreres prospect and inspect our for rent by owner website and hear exotic castle and penthouse timeshare.
Vitoria land owners, property agents, brokers leasing foreclosures, and rental agents list Vitoria Brazil real estate rentals, Vitoria Brazil real estate rentals, and Vitoria house rentals.
Glimpse, ascertain, and ascertain vacation rental Campo Grande, Campo Grande Brazil short term rentals, and bed and breakfast rentals in Campo Grande Brazil.
Our website, FRBO.com does incorporate special turf waterfront, hidden, ski in/out, and exotic bungalow, flat, ranch, and chalets.
Vitoria Brazil is a handsome and excellent zone with fair and alluring bungalow, cottage, lodge, and chalets.
Glimpse, perceive, and debunk rental home in Barreiras, apartments for rent Barreiras, and rental home in Barreiras.
Ascertain, identify, and relocate Taubaté Brazil vacation homes for rent by owner, real estate rentals in Taubaté Brazil, and short term rentals Taubaté.
|
|
