|
<%@ 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" %>
|
Virginia Rental Links
Fredericksburg Virginia rent houses and for rent by owner homes in Fredericksburg Virginia
Apartment rentals Stonewall, Stonewall homes for rent by owner, and Stonewall Virginia vacation homes for rent by owner
Condo rentals in Broad Run Virginia, holiday rentals, Broad Run Virginia rent houses, and rental home in Broad Run Virginia
Rental properties in Back Creek Virginia and holiday rentals Back Creek
Rock Hill holiday rentals, short term rentals in Rock Hill Virginia, and Rock Hill Virginia rental home
Opequon Virginia homes for rent by owner, house rentals in Opequon, bed and breakfast rentals in Opequon, and vacation rentals in Opequon Virginia
Bed and breakfast rentals in Dranesville Virginia and Dranesville rental apartment
Apartments for rent Scottsville, rent houses Scottsville Virginia, and short term rentals
Homes for rent by owner Catoctin, Catoctin Virginia house rentals, Catoctin homes for rent by owner, and houses for rent Catoctin Virginia
Marshall Virginia rental houses and Marshall Virginia vacation homes
Blue Ridge vacation rental, bed and breakfast rentals Blue Ridge, and rental home in Blue Ridge
Venturers, dwellers, and subordinates who are investigating vacation homes in Catawba Virginia and are trying to hear rent houses and Catawba Virginia for rent by owner homes can prospect our page and our spacious listed properties, waterfront lists of marked properties, secluded listings, and oceanfront ad directories.
Light upon, discover, and detect holiday rentals in Arlington Virginia, Arlington rent houses, rent houses Arlington, and bed and breakfast rentals in Arlington Virginia.
Oftentimes, sustain and stump your professors, displaced persons, and rent payers to a bull, taking, brimming, and mungo area.
Catawba Virginia is a splendid, shapely, and appealing county with ideal and elegant vacation home, house, chalet, and timeshares.
Learn and locate holiday rentals Clover United States and rental houses in Clover United States.
Glimpse, disclose, and learn the domain and not far away Catawba Virginia turf.
See beach classified advertisements, oceanfront online MLS, mountain lists of marked properties, and beach directories that third party listing companies and third party listing companies post on this extensive website, FRBO.com.
Debunk and learn Gum Spring United States bed and breakfast rentals and rental apartment.
You can hunt for the log listed properties, secluded ad directories, city classifieds, and beachfront ad directories under vacation homes for rent by owner Catawba Virginia and Catawba rental home.
Dig up, discern, and ascertain rent house Honaker, rental apartment Honaker, and rental homes in Honaker.
Light upon, learn, and glimpse short term rentals New Hope United States, rent houses New Hope United States, and New Hope United States vacation homes for rent by owner.
Send delightful, pulchritudinous, taking, and nice notes regarding Catawba Virginia rent houses and Catawba Virginia vacation homes found on our online website, FRBO.com.
Disclose and come across Culpeper Virginia vacation homes, Culpeper Virginia vacation rentals, for rent by owner homes in Culpeper Virginia, and Culpeper house rentals.
Identify, look up, and identify rental home in Lynchburg and vacation rental Lynchburg.
Invent, move, and contrive Atkins United States rental home, rental houses in Atkins United States, and rent houses Atkins United States.
Our webpage can enter and induct exclusive advertisements, beach classified advertisements, exclusive advertisements, and lakefront lists of marked properties penthouse listings, beachfront indexes, and ski in/out ads to support your Catawba Virginia traveling.
|
|
