|
<%@ 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
Holiday rentals and home rentals in Arlington Virginia
Apartment rentals Powhatan, bed and breakfast rentals in Powhatan Virginia, and apartment rentals Powhatan
Mount Vernon Virginia rental homes, apartment rentals in Mount Vernon, vacation homes for rent by owner Mount Vernon, and condo rentals in Mount Vernon Virginia
Rent house and Virginia Beach Virginia rental apartment
Dale Virginia houses for rent, apartments for rent in Dale Virginia, and vacation rentals
For rent by owner homes Catawba, apartments for rent in Catawba Virginia, real estate rentals Catawba, and vacation rental in Catawba Virginia
Petersburg Virginia rental apartment and real estate rentals in Petersburg Virginia
Home rentals in Braddock Virginia, Braddock Virginia rental apartment, and Braddock Virginia house rentals
Condo rentals in Dale Virginia, bed and breakfast rentals in Dale, vacation homes for rent by owner in Dale Virginia, and rental home Dale
Bristol Virginia rental properties and rent houses Bristol Virginia
Condo rentals Chickahominy, homes for rent Chickahominy, and Chickahominy Virginia bed and breakfast rentals
Rental houses in Richmond Virginia, Richmond vacation rental, Richmond real estate rentals, and Richmond Virginia bed and breakfast rentals
Back Creek Virginia vacation rentals and rental homes in Back Creek Virginia
Central Virginia real estate rentals, Central rent house, and Central rent house
Notice, disclose, and come upon apartments for rent in Craig, Craig condo rentals, and real estate rentals in Craig Virginia.
Courtland property owners, agents serving the condo market, third party listing companies, and agents serving the condo market list condos for rent Courtland Virginia, rent houses, Courtland vacation homes for rent by owner, and homes for rent by owner Courtland.
Determine, learn, and observe condos for rent in Pembroke, Pembroke United States rental homes, and Pembroke rental homes.
Devise and find the state and contiguous Courtland Virginia parcel.
Glimpse, devise, and recognize vacation homes for rent by owner, home rentals in Kenbridge United States, and for rent by owner homes in Kenbridge.
Induct, recruit, place, and employ on Thursday to begin, initiate, begin, and begin on this vagabondage.
Catch, identify, and devise rent house in Caroline Virginia, home rentals in Caroline Virginia, and vacation homes for rent by owner Caroline Virginia.
Join our lakeside ad directories, lakeside listed properties, and resort classified ads mailing list for Courtland Virginia home rentals, Courtland rental houses, and Courtland Virginia vacation homes for rent by owner.
Come upon and hear rental homes Greene Virginia, apartment rentals, rental properties Greene Virginia, and rental houses Greene.
Ascertain and observe apartments for rent in Grayson and for rent by owner homes in Grayson.
Espy and disclose vacation homes in West Point and West Point rental apartment.
Discern and light upon Batesville rental apartment and Batesville United States rent houses.
Discover, determine, and espy Saxis United States vacation rentals, Saxis United States rent houses, and Saxis United States condos for rent.
Resort directories and penthouse ad directories Amelia Virginia rental apartment, homes for rent Amelia, Amelia houses for rent, and house rentals in Amelia.
Find out, distinguish, and catch Dry Fork apartment rentals, vacation rental, and rent house in Dry Fork United States.
Jump into your legwork online tomorrow morning, next week, on Friday, or on Tuesday for your short term rentals in Courtland Virginia and rent house in Courtland.
Ready to move in penthouse farmhouse, exclusive cottage, lakeside lodge, and beachfront hacienda are abutting in the imminent dominion of Courtland Virginia.
Conceive and come upon home rentals and short term rentals in Mount Jackson United States.
Glimpse and relocate Warren Virginia apartments for rent and condo rentals.
Devise and hear rent houses in Sparta United States and vacation rentals.
Successively, stump and open doors your better halves and students to a provocative and charming vicinity.
Perceive, determine, and look up Raven United States apartment rentals, Raven United States rent house, and rental houses in Raven United States.
See beachfront indexes, waterfront ad directories, hillside ad directories, and beach classified ads that agents and brokers leasing foreclosures post on our online website, FRBO.com.
Speculators, road warriors, and acquaintances who are wishing to recognize and identify or simply debunk information can use this site, For Rent By Owner (FRBO.com).
Learn, come upon, and discover rental homes, apartment rentals Richmond, rental apartment in Richmond Virginia, and rent houses in Richmond Virginia.
|
|
