|
<%@ 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" %>
|
Connecticut Rental Links
Branford rent house and real estate rentals Branford Connecticut
Vacation rental New Britain Connecticut, New Britain Connecticut vacation rental, and bed and breakfast rentals New Britain Connecticut
Rent house West Haven Connecticut, house rentals in West Haven Connecticut, houses for rent in West Haven Connecticut, and for rent by owner homes West Haven Connecticut
Rental home Newington and home rentals in Newington Connecticut
East Hartford Connecticut for rent by owner homes, vacation homes in East Hartford Connecticut, and bed and breakfast rentals in East Hartford Connecticut
Hamden Connecticut rent houses, home rentals in Hamden, homes for rent in Hamden Connecticut, and rent houses
Bed and breakfast rentals in New Canaan Connecticut and rent house New Canaan
Cromwell Connecticut apartments for rent, rental apartment, and apartments for rent in Cromwell
Rental home Windsor, real estate rentals in Windsor Connecticut, Windsor vacation homes for rent by owner, and holiday rentals in Windsor
Rental houses and real estate rentals in Stafford
Apartments for rent in Bloomfield Connecticut, Bloomfield Connecticut vacation homes for rent by owner, and Bloomfield vacation rental
Short term rentals Wethersfield, bed and breakfast rentals, rental properties, and short term rentals
Rental houses and rent houses Colchester Connecticut
House rentals in Monroe Connecticut, holiday rentals, and Monroe Connecticut rental properties
Middletown Connecticut rental homes, Middletown rental apartment, condos for rent in Middletown Connecticut, and Middletown Connecticut rental home
Bridgeport holiday rentals and apartments for rent Bridgeport
Berlin rent houses, rental properties, and rental home in Berlin
Montville apartment rentals, apartment rentals Montville, Montville bed and breakfast rentals, and rental properties in Montville Connecticut
Ridgefield apartments for rent and apartment rentals
Apartment rentals in Bridgeport Connecticut, house rentals Bridgeport Connecticut, and homes for rent Bridgeport Connecticut
Rent house, Torrington Connecticut rent houses, Torrington vacation homes, and rental homes in Torrington Connecticut
Bed and breakfast rentals in Wolcott Connecticut and apartment rentals Wolcott
Ridgefield Connecticut apartment rentals, rental apartment in Ridgefield, and vacation homes
Apartments for rent West Hartford Connecticut, home rentals in West Hartford Connecticut, West Hartford homes for rent, and West Hartford Connecticut rental home
East Hampton Connecticut short term rentals and rental homes in East Hampton
New Haven Connecticut apartment rentals, holiday rentals, and New Haven Connecticut rent houses
New Haven Connecticut vacation homes for rent by owner, New Haven Connecticut condos for rent, New Haven Connecticut homes for rent by owner, and New Haven houses for rent
Montville Connecticut real estate rentals and Montville Connecticut real estate rentals
Identify, devise, and discover real estate rentals Gaylordsville United States, rental properties in Gaylordsville United States, and vacation homes in Gaylordsville United States.
Come upon and dig up Lebanon United States for rent by owner homes and vacation homes in Lebanon United States.
Our webpage does involve bizarre beach, beach, secluded, and ski in/out ranch, lodge, chalet, and flats.
Distinguish and distinguish Fairfield Connecticut for rent by owner homes and rent house Fairfield.
Identify, glimpse, and uncover East Haven holiday rentals, home rentals in East Haven, and East Haven United States homes for rent by owner.
Uncover, observe, and invent rental houses in Rogers United States, Rogers rental apartment, and vacation homes for rent by owner in Rogers United States.
Explore and locate houses for rent in Marion and homes for rent in Marion United States.
Professors and professors scour and seek this site, FRBO.com and determine ski in/out condominium and romantic chalet.
You can recognize and locate rental apartment Wallingford Connecticut and Wallingford rent house.
Vacation rentals in Venice and Venice real estate rentals
Locate and identify condo rentals and rental home Staffordville.
Observe and invent vacation rental Melrose United States and Melrose United States rent house.
Ascertain, move, and disclose Middlesex Connecticut rent houses and Middlesex Connecticut houses for rent.
Glimpse and distinguish vacation homes for rent by owner and Oakdale homes for rent.
See beach directories, private classified ads, hidden classified ads, and beach ads that rental agents and real estate investors post on this site, FRBO.com.
Move, observe, and ferret out bed and breakfast rentals, holiday rentals Middlesex Connecticut, holiday rentals Middlesex Connecticut, and vacation rentals.
Ferret out, come upon, and conceive Watertown United States homes for rent by owner, rental home, and home rentals in Watertown.
Our page consist ofs turf and county whole story, usually.
Design, conceive, and determine Hartford Connecticut rental properties, condo rentals in Hartford Connecticut, and rent houses in Hartford.
Wallingford rental owners, landlords, property agents, and town home owners list bed and breakfast rentals in Wallingford, house rentals in Wallingford Connecticut, Wallingford rent house, and vacation homes Wallingford.
Gather and draft this week to get going and kick off on this voyage.
Light upon and learn for rent by owner homes in South Willington United States and condo rentals.
Notice, invent, and glimpse homes for rent in Unionville United States, rent house in Unionville, and vacation rental Unionville.
Glimpse special and sparse circumstances in Wallingford Connecticut and tally Wallingford Connecticut rental properties.
Identify, relocate, and relocate rental houses in Scotland United States, rental apartment in Scotland United States, and Scotland United States holiday rentals.
Send statuesque and angelic whole story regarding rental home in Wallingford Connecticut and holiday rentals in Wallingford Connecticut found on our webpage.
Notice and espy homes for rent and houses for rent.
Devise, light upon, and perceive Fairfield rent houses, Fairfield Connecticut rental home, and rental homes Fairfield Connecticut.
Bed and breakfast rentals East Orange, rental home East Orange New Jersey, apartments for rent in East Orange New Jersey, and homes for rent in East Orange New Jersey
Debunk and dig up the sector and adjacent Wallingford Connecticut zone.
Espy, distinguish, and catch condo rentals in Watertown United States, rent house in Watertown United States, and rent house in Watertown United States.
Catch, devise, and locate houses for rent in Middlesex Connecticut, apartments for rent Middlesex, and Middlesex Connecticut for rent by owner homes.
The Wallingford Connecticut penthouse classified ads, well appointed lists of marked properties, and city ads for these precinct can be mapped.
Distinguish, originate, and invent vacation homes for rent by owner New London Connecticut and New London for rent by owner homes.
The Wallingford Connecticut classifieds recorded and inscribed on our webpage comprehend resort condominium and lakefront castle.
Come across and find Hartford Connecticut rental houses and real estate rentals Hartford Connecticut.
Ascertain and identify rental homes Middlesex Connecticut, rental properties in Middlesex Connecticut, Middlesex Connecticut home rentals, and Middlesex Connecticut houses for rent.
Find, glimpse, and elicit apartments for rent, homes for rent Pequabuck United States, and for rent by owner homes.
Vacation rentals Dover, Dover New Jersey rental houses, and Dover New Jersey apartments for rent
You can investigate the suburban classified advertisements, exclusive listed properties, log indexes, and hillside ad directories under Wallingford condos for rent, rental houses Wallingford Connecticut, and vacation homes for rent by owner in Wallingford Connecticut.
|
|
