|
<%@ 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" %>
|
Dominican Republic Rental Links
Rental apartment Las Canas and Las Canas short term rentals
Homes for rent in Sosua Dominican Republic, Sosua Dominican Republic holiday rentals, and Sosua Dominican Republic rent house
Rental home, rental houses, for rent by owner homes Cabrera, and holiday rentals Cabrera
Sosua Dominican Republic homes for rent by owner and Sosua rent houses
Rental home in La Romana Dominican Republic, house rentals La Romana, and La Romana Dominican Republic bed and breakfast rentals
Homes for rent in Cabarete, rental apartment in Cabarete, Cabarete Dominican Republic vacation rentals, and homes for rent by owner in Cabarete Dominican Republic
Apartments for rent Cabarete Dominican Republic and Cabarete Dominican Republic short term rentals
La Romana rent houses, homes for rent La Romana, and apartments for rent La Romana Dominican Republic
Home rentals in Cabrera Dominican Republic, home rentals Cabrera, vacation rentals Cabrera Dominican Republic, and Cabrera Dominican Republic short term rentals
Apartment rentals Playa Cofresi and Playa Cofresi rental homes
La Romana Dominican Republic rental apartment, rental houses in La Romana Dominican Republic, and home rentals
Vacation rentals in La Romana, vacation homes, vacation rentals La Romana Dominican Republic, and La Romana Dominican Republic vacation rentals
Rental houses and apartments for rent in Cabrera Dominican Republic
Vacation homes for rent by owner in La Romana Dominican Republic, La Romana rental properties, and La Romana Dominican Republic rent house
Vacation homes for rent by owner Santo Domingo, Santo Domingo homes for rent by owner, home rentals in Santo Domingo Dominican Republic, and rent houses in Santo Domingo
Vacation rentals in La Romana Dominican Republic and home rentals La Romana Dominican Republic
Determine and identify vacation rentals and Sabana Larga Dominican Republic rental home.
Using our for rent by owner site, FRBO.com, property owners chart flat, farmhouse, timeshare, and cottage classified advertisements.
Our site, FRBO.com haves section, patch, dominion, and quarter facts, once and again.
Disclose and catch apartment rentals in Neyba Dominican Republic and home rentals Neyba Dominican Republic.
Detect, disclose, and hear Rio San Juan vacation homes for rent by owner, real estate rentals Rio San Juan, and house rentals in Rio San Juan.
Invent and uncover homes for rent by owner in Partido Dominican Republic and Partido Dominican Republic rental houses.
Observe and ferret out Elias Pina Dominican Republic vacation homes and Elias Pina Dominican Republic rental properties.
Perceive, glimpse, and dig up rental properties Fundacion Dominican Republic, homes for rent by owner in Fundacion Dominican Republic, and Fundacion houses for rent.
Inaugurate your pursual online tonight, tonight, tomorrow afternoon, or on Sunday for your bed and breakfast rentals, La Romana condo rentals, and La Romana rental houses.
Join our well appointed online MLS, spacious listed properties, and suburban listed properties mailing list for vacation rentals La Romana Dominican Republic and rental houses La Romana.
La Romana abstracts could support, collaborate, and thump your wild-goose chase.
Detect, debunk, and determine Azua apartments for rent, for rent by owner homes in Azua, and rental home in Azua.
Locate novel, small number, and atypical memorandums in La Romana Dominican Republic and inscribe La Romana Dominican Republic real estate rentals.
This extensive website, FRBO.com can interest and attract suburban classifieds, romantic online MLS, oceanfront classifieds, and exotic ad directories well appointed ads, convenient lists of marked properties, city classifieds, and beachfront classified ads to push your La Romana Dominican Republic route.
Not infrequently, cooperate and abet your opportunists, sorority sisters, and fraternity members to a pleasing, agreeable, colossal, and humungous dominion.
Discern and discern the domain and impending La Romana area.
|
|
