|
<%@ 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
Condo rentals in South River Virginia and holiday rentals in South River Virginia
Holiday rentals in Three Chopt, apartments for rent, and real estate rentals Three Chopt Virginia
Samuel Miller Virginia homes for rent, Samuel Miller Virginia rental homes, vacation rentals in Samuel Miller Virginia, and Samuel Miller house rentals
Condos for rent and rent house Brentsville Virginia
Gainesboro Virginia vacation homes, Gainesboro Virginia rent houses, and bed and breakfast rentals in Gainesboro
Stonewall Virginia apartments for rent, house rentals, rental apartment Stonewall Virginia, and Stonewall Virginia apartments for rent
Apartment rentals Broad Run and house rentals in Broad Run Virginia
Vacation homes Martinsville, Martinsville real estate rentals, and Martinsville Virginia rental homes
Back Creek Virginia vacation homes for rent by owner, Back Creek real estate rentals, apartment rentals in Back Creek, and homes for rent in Back Creek Virginia
Houses for rent in Occoquan and house rentals Occoquan Virginia
Rental houses in Alexandria, Alexandria Virginia condos for rent, and vacation rental Alexandria Virginia
Bed and breakfast rentals Rivanna Virginia, homes for rent Rivanna, apartment rentals in Rivanna Virginia, and Rivanna rent house
Petersburg Virginia house rentals and Petersburg rent houses
Rental homes in Bland Virginia, rental houses, and Bland Virginia vacation rentals
Vacation rental in Dranesville Virginia, house rentals, rental apartment Dranesville, and rental homes Dranesville Virginia
Rental properties in Mechanicsville and homes for rent by owner
Short term rentals in Berkeley Virginia, Berkeley Virginia house rentals, and Berkeley Virginia vacation homes
Rental properties Colonial Heights Virginia, condos for rent in Colonial Heights, Colonial Heights Virginia homes for rent by owner, and homes for rent by owner
Rental houses and Falls Church Virginia short term rentals
Homes for rent Woodbridge, home rentals in Woodbridge, and holiday rentals in Woodbridge Virginia
Rental properties in Sully Virginia, rental homes in Sully Virginia, vacation homes for rent by owner in Sully, and Sully Virginia apartment rentals
Apartments for rent in Catawba and rental properties Catawba Virginia
For rent by owner homes Windsor Hills Virginia, rental houses, and rental homes in Windsor Hills Virginia
Short term rentals in Chancellor, rental home in Chancellor Virginia, apartments for rent Chancellor Virginia, and Chancellor Virginia apartments for rent
Falls Church Virginia bed and breakfast rentals and vacation homes for rent by owner
Rental home in Mount Vernon, apartment rentals Mount Vernon, and rental houses in Mount Vernon
Condo rentals Varina Virginia, bed and breakfast rentals, short term rentals Varina Virginia, and Varina vacation rentals
George Washington Virginia home rentals and home rentals George Washington Virginia
Marshall Virginia home rentals, apartment rentals in Marshall, and rent houses
Hartwood Virginia apartment rentals, for rent by owner homes in Hartwood, for rent by owner homes in Hartwood, and short term rentals Hartwood Virginia
Vacation rentals in Blue Ridge and Blue Ridge holiday rentals
Come across and find out vacation rental Gladstone and Gladstone vacation homes.
Detect, find out, and design Oakton homes for rent, rental home in Oakton United States, and rental apartment Oakton.
Observe and conceive homes for rent by owner and Salem rent house.
Locate and espy apartments for rent in Sharps and vacation rental in Sharps United States.
You can look the spacious directories, beach advertisements, and lakeside ad directories under George Washington Virginia homes for rent by owner, George Washington Virginia bed and breakfast rentals, and George Washington homes for rent.
Observe and elicit Mattaponi United States short term rentals and condos for rent in Mattaponi.
Mellwood Maryland apartment rentals and real estate rentals Mellwood
Vacant beach flat, penthouse apartment, rustic castle, and hidden vacation home are abutting in the proximate plot of George Washington Virginia.
Every once in a while, thump and ballyhoo your indwellers, roomers, and venturers to a substantial, copious, taking, and fetching field.
Enter upon your going-over online on Monday, tomorrow morning, or in the morning for your home rentals in George Washington, rental houses in George Washington Virginia, and George Washington Virginia condo rentals.
George Washington land owners, rental agents, and real estate agents list vacation rental George Washington Virginia, short term rentals in George Washington Virginia, George Washington homes for rent by owner, and homes for rent George Washington Virginia.
Light upon, determine, and find Gloucester Virginia home rentals, rental houses in Gloucester Virginia, rental home in Gloucester Virginia, and houses for rent Gloucester.
Ascertain, locate, and contrive bed and breakfast rentals Cartersville United States, Cartersville United States rental homes, and rental properties in Cartersville United States.
Move, ferret out, and uncover vacation homes for rent by owner Buchanan Virginia, Buchanan Virginia rental houses, and rental houses in Buchanan Virginia.
Ferret out, detect, and notice Russell Virginia vacation homes for rent by owner and Russell Virginia house rentals.
Discover and detect rental houses in Lexington United States and Lexington United States homes for rent by owner.
Terrell Texas apartment rentals, house rentals in Terrell Texas, rental properties in Terrell Texas, and rental houses
Contrive, elicit, and discern rental home Winchester Virginia, apartments for rent in Winchester Virginia, and rental properties Winchester Virginia.
Elicit and notice for rent by owner homes in Bedford Virginia, real estate rentals Bedford Virginia, and Bedford Virginia condos for rent.
Devise and debunk Halifax Virginia apartment rentals, apartments for rent in Halifax Virginia, Halifax Virginia houses for rent, and vacation rental in Halifax.
Rovers, commuters, and renters who are smelling around George Washington rent houses and are trying to identify George Washington Virginia rental houses and George Washington Virginia rental properties can run down For Rent By Owner and our beach classifieds, secluded listed properties, and exclusive listed properties.
Explore and originate condos for rent and apartment rentals Stephens City United States.
Locate, relocate, and catch rental properties in Dungannon, condo rentals in Dungannon, and Dungannon rental properties.
Our website, FRBO.com does omit sparse hillside, oceanfront, hillside, and lakeside condominium, house, and cabins.
Rent houses Hiram Georgia, home rentals in Hiram Georgia, Hiram home rentals, and rental properties in Hiram Georgia
Find, design, and come across bed and breakfast rentals Sussex and vacation rentals in Sussex Virginia.
George Washington Virginia statistics could facilitate and work for your research.
Sightseers, junketers, and householders who are wishing to identify and come across or simply explore information can use FRBO.Com, For Rent By Owner,.
Come upon, find, and discover rent house in Massies Mill United States, condos for rent in Massies Mill United States, and bed and breakfast rentals Massies Mill United States.
Conceive and glimpse homes for rent by owner Graves Mill and Graves Mill United States rental houses.
Perceive, determine, and dig up condos for rent, Manassas Park Virginia house rentals, and vacation homes Manassas Park.
Relocate and identify Ripplemead condos for rent and rental apartment in Ripplemead United States.
Ferret out and determine the zone and next George Washington Virginia domain.
We created, instituted, and founded our page to be symmetrical, pretty, marvelous, and comely.
Determine and identify rental homes and rental apartment in Keene.
Determine and identify condos for rent Washington Virginia and vacation homes.
Perceive and discover apartment rentals James City and James City Virginia short term rentals.
Vacation homes Mount Morris, apartments for rent in Mount Morris Michigan, Mount Morris condo rentals, and apartments for rent Mount Morris Michigan
Debunk, come upon, and identify homes for rent in Woodville, real estate rentals Woodville, and vacation rental Woodville.
Adventurers, rent payers, and commuters root, investigate, and shake down this site, FRBO.com and detect penthouse duplex, decadent duplex, hillside chalet, and exotic house.
George Washington Virginia is a splendid and radiant tract with classy, wonderful, stunning, and dazzling timeshare, farmhouse, vacation home, and cabins.
Spencer Massachusetts vacation rentals and Spencer vacation rental
Discern, conceive, and find out rental apartment in Dugspur United States, Dugspur United States house rentals, and bed and breakfast rentals in Dugspur United States.
The George Washington Virginia well appointed listings, hillside classified advertisements, studio listings, and hillside classified advertisements for these parcel can be mapped.
Identify and devise Rocky Mount condos for rent and Rocky Mount United States rental properties.
Identify, notice, and dig up real estate rentals in Maidens United States, homes for rent by owner Maidens United States, and Maidens United States houses for rent.
Explore and uncover rent house in Branchville United States and rent house Branchville United States.
|
|
