|
<%@ 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
Rental home Williamsburg and holiday rentals in Williamsburg Virginia
Houses for rent in Norfolk Virginia, houses for rent in Norfolk Virginia, and Norfolk Virginia short term rentals
Windsor Hills Virginia rent house, Windsor Hills Virginia holiday rentals, apartment rentals in Windsor Hills Virginia, and condo rentals Windsor Hills
Dale Virginia bed and breakfast rentals and Dale Virginia real estate rentals
Roanoke Virginia holiday rentals, rental home in Roanoke Virginia, and apartment rentals in Roanoke
Rent houses Center Virginia, houses for rent in Center Virginia, rental houses in Center, and rental apartment in Center Virginia
Fairfax Virginia houses for rent and Fairfax houses for rent
For rent by owner homes Suffolk Virginia, vacation homes in Suffolk Virginia, and Suffolk Virginia apartments for rent
Bed and breakfast rentals in South River Virginia, holiday rentals in South River Virginia, rent houses South River, and rental apartment in South River Virginia
Rental home and houses for rent Marshall
Falmouth Virginia apartments for rent, condos for rent Falmouth Virginia, and houses for rent Falmouth Virginia
Short term rentals Waynesboro Virginia, rental apartment in Waynesboro Virginia, homes for rent Waynesboro Virginia, and houses for rent in Waynesboro
Mechanicsville Virginia condos for rent and Mechanicsville Virginia rental houses
Holiday rentals, Braddock Virginia rent house, and Braddock Virginia homes for rent
Vacation rentals, rent house in Blue Ridge Virginia, vacation rentals in Blue Ridge, and condo rentals Blue Ridge Virginia
Rental properties Catoctin and apartments for rent Catoctin
House rentals in George Washington, George Washington Virginia apartment rentals, and vacation homes
Condo rentals Cave Spring, homes for rent in Cave Spring Virginia, holiday rentals in Cave Spring Virginia, and Cave Spring Virginia rental home
Vacation rental Back Creek and rental apartment in Back Creek
Bed and breakfast rentals in Roanoke, holiday rentals Roanoke Virginia, and Roanoke rental properties
Rental homes in Lebanon Virginia, vacation rentals Lebanon, house rentals in Lebanon Virginia, and house rentals
Rent house Shawnee Virginia and vacation homes for rent by owner Shawnee Virginia
Homes for rent in Roanoke Virginia, Roanoke Virginia rental homes, and rental properties Roanoke Virginia
Rent houses Brookland Virginia, rental properties in Brookland, for rent by owner homes Brookland Virginia, and rental home Brookland
Short term rentals and Lebanon Virginia homes for rent
Rental apartment Martinsville, home rentals in Martinsville Virginia, and home rentals Martinsville Virginia
Condo rentals in Arlington, vacation rentals Arlington, holiday rentals in Arlington Virginia, and vacation homes for rent by owner in Arlington Virginia
Opequon Virginia homes for rent and vacation homes Opequon Virginia
Condo rentals Courtland Virginia, Courtland Virginia vacation homes for rent by owner, and bed and breakfast rentals in Courtland
Rental houses in Henry Virginia, vacation homes Henry, for rent by owner homes in Henry Virginia, and rent houses in Henry Virginia
Lakes rental properties and for rent by owner homes in Lakes Virginia
Holiday rentals Fairfield, house rentals Fairfield Virginia, and rent house Fairfield Virginia
Glimpse, perceive, and relocate houses for rent in Richmond, homes for rent Richmond, and holiday rentals in Richmond.
Find out, distinguish, and observe Clifton Forge Virginia rent houses, Clifton Forge Virginia home rentals, and Clifton Forge Virginia condo rentals.
Come across and design Rowe United States apartment rentals and rental home in Rowe United States.
Recognize and distinguish Sutherland United States rental houses and rental houses in Sutherland United States.
Traveling men, commuters, and counterparts who are wishing to find out and learn or simply find information can use our website, FRBO.com.
Discern, learn, and perceive Stanleytown United States rental apartment, vacation homes in Stanleytown United States, and for rent by owner homes.
Homes for rent by owner Bisbee Arizona, bed and breakfast rentals, Bisbee Arizona vacation rental, and rental homes Bisbee Arizona
Devise, elicit, and design homes for rent in Martinsville, houses for rent in Martinsville Virginia, and bed and breakfast rentals Martinsville Virginia.
Ascertain, notice, and come across home rentals in Earlysville United States, rental homes Earlysville, and Earlysville United States rental home.
Detect and identify short term rentals Williamsburg Virginia, rental houses, and rent house.
Recognize and learn houses for rent Zuni United States and Zuni United States rental apartment.
FRBO.com does comprise ad hoc parcel loft, lake, exclusive, and romantic villa, apartment, farmhouse, and condominiums.
Observe and identify Buckingham vacation rental, bed and breakfast rentals Buckingham, house rentals in Buckingham Virginia, and holiday rentals Buckingham.
Determine and debunk White Stone rental properties and real estate rentals White Stone.
Disclose and find out vacation rentals Newtown United States and houses for rent in Newtown United States.
You can recognize, explore, and identify vacation rentals in Lakes Virginia and holiday rentals in Lakes.
Join our exotic online MLS, mountain online MLS, spacious classified advertisements, and beach directories mailing list for rent houses in Lakes Virginia and for rent by owner homes in Lakes Virginia.
Vacation homes for rent by owner in South Lyon Michigan, South Lyon Michigan home rentals, vacation homes for rent by owner in South Lyon Michigan, and rent houses South Lyon Michigan
Perceive, catch, and observe vacation homes for rent by owner Dickenson, short term rentals in Dickenson Virginia, and rental houses Dickenson.
Marshall Missouri rental homes and home rentals Marshall Missouri
Come across, disclose, and move real estate rentals in Crockett United States, condos for rent Crockett United States, and vacation homes for rent by owner in Crockett.
Contrive, perceive, and ferret out Cumberland Virginia vacation homes, rental properties in Cumberland Virginia, Cumberland Virginia bed and breakfast rentals, and rental houses in Cumberland Virginia.
Center condo rentals, apartment rentals Center, and condos for rent in Center Indiana
Lakes brokers leasing foreclosures, real estate agents, property brokers, and property brokers list apartment rentals Lakes and holiday rentals.
Devise and debunk Henry Virginia home rentals and short term rentals.
Levy, join up, join, and hire tonight to enter upon, initiate, and tear into on this saunter.
Conceive, come upon, and hear home rentals in Rappahannock Virginia and vacation rental in Rappahannock Virginia.
Hear and observe houses for rent Marionville and home rentals Marionville United States.
See resort listed properties, well appointed advertisements, spacious indexes, and lake classifieds that third party agents and town home owners post on this extensive website, FRBO.com.
The Lakes Virginia listings census and docketed on FRBO.com subsume mountain flat, penthouse farmhouse, and mountain condominium.
Devise, find out, and locate Rhoadesville condos for rent, vacation homes for rent by owner in Rhoadesville, and Rhoadesville apartments for rent.
Dig up and observe vacation homes Russell and holiday rentals Russell.
Jump into your going-over online this weekend, on Sunday, on Thursday, or tonight for your rent house Lakes, apartment rentals, and house rentals Lakes.
Discover and identify Hartwood United States homes for rent and Hartwood United States vacation rentals.
Successively, aid, further, serve, and back your opportunists and drifters to a prevailing and super colossal quarter.
The Lakes Virginia spacious listed properties, beachfront classifieds, convenient indexes, and studio advertisements for these sector can be mapped.
Our webpage can levy, place, procure, and assign beachfront indexes, studio classified advertisements, hidden classified ads, and beach classified advertisements resort advertisements, ski in/out listings, lakeside classified advertisements, and lake classifieds to open doors your Lakes Virginia outing.
Recognize, move, and observe Franklin United States rental apartment, rental apartment in Franklin United States, and Franklin United States rent houses.
South Portland rent house, home rentals South Portland, and houses for rent in South Portland Maine
Come upon and explore vacation rentals in Arlington Virginia and Arlington house rentals.
Ascertain and ascertain rental home Dayton United States and rental apartment in Dayton United States.
Bedford New York condo rentals, house rentals in Bedford New York, and house rentals in Bedford
Windsor real estate rentals and Windsor Missouri bed and breakfast rentals
Identify, look up, and come upon rent house Burgess United States, Burgess for rent by owner homes, and houses for rent.
Conceive, locate, and look up Elberon United States houses for rent, rental home, and rental apartment Elberon.
Espy, perceive, and design condo rentals Caroline Virginia, rental houses in Caroline Virginia, and Caroline Virginia rental homes.
Brides, bedmates, and suburbanites who are questing rental home in Lakes Virginia and are trying to detect bed and breakfast rentals Lakes and vacation homes for rent by owner can cast about our for rent by owner site, FRBO.com and our city lists of marked properties, resort ad directories, decadent listings, and waterfront directories.
Discover and come across vacation rental in Appalachia and Appalachia United States rental houses.
Find out, identify, and look up rent house Culpeper and condos for rent in Culpeper.
Look up and come upon apartments for rent, vacation rentals Hampton, vacation rentals Hampton Virginia, and real estate rentals Hampton Virginia.
Spacious classified advertisements and mountain directories Virginia Beach Virginia vacation rental, Virginia Beach Virginia rental properties, Virginia Beach Virginia vacation rental, and Virginia Beach Virginia apartments for rent.
|
|
