|
<%@ 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
Griswold Connecticut vacation homes and Griswold Connecticut vacation rental
Vacation homes for rent by owner in Groton Connecticut, homes for rent by owner, and rental homes Groton
Southington rent house, apartment rentals in Southington Connecticut, apartment rentals Southington, and holiday rentals in Southington
Plymouth Connecticut apartment rentals and vacation rentals in Plymouth Connecticut
Rental apartment Windsor, condos for rent in Windsor, and rental homes in Windsor Connecticut
Vacation rentals Greenwich, Greenwich Connecticut vacation rental, rent houses, and real estate rentals Greenwich
Rent house Darien and Darien Connecticut house rentals
Rent house Bridgeport, Bridgeport Connecticut vacation rentals, and Bridgeport Connecticut real estate rentals
Condos for rent, rental houses Derby Connecticut, real estate rentals Derby Connecticut, and condo rentals in Derby Connecticut
Rental properties in West Haven Connecticut and rental houses in West Haven
Rental properties in Southington Connecticut, vacation homes for rent by owner Southington, and rental homes Southington Connecticut
Apartment rentals in Windham Connecticut, houses for rent in Windham Connecticut, vacation rental in Windham, and Windham Connecticut homes for rent by owner
Short term rentals in Stratford and bed and breakfast rentals
Bloomfield Connecticut apartments for rent, rental homes in Bloomfield Connecticut, and vacation rental Bloomfield
Home rentals Rocky Hill, home rentals, Rocky Hill Connecticut holiday rentals, and Rocky Hill Connecticut bed and breakfast rentals
For rent by owner homes in Orange and real estate rentals in Orange
Montville Connecticut home rentals, Montville Connecticut rental properties, and bed and breakfast rentals
Hartford Connecticut rental home, Hartford Connecticut homes for rent, apartment rentals Hartford, and rental properties
Home rentals in Manchester and houses for rent in Manchester
Homes for rent in Brookfield Connecticut, home rentals in Brookfield, and vacation rentals
Apartments for rent Clinton Connecticut, vacation rentals, home rentals, and vacation rentals in Clinton Connecticut
Rental houses in Meriden and rent house
Vacation homes New London, real estate rentals New London Connecticut, and New London Connecticut homes for rent
Condos for rent in East Hartford, short term rentals, homes for rent by owner, and homes for rent in East Hartford Connecticut
For rent by owner homes Wethersfield Connecticut and Wethersfield rent houses
House rentals in Westport, short term rentals, and short term rentals in Westport
Distinguish and discern home rentals in Hartford Connecticut, rental houses Hartford, rental properties in Hartford Connecticut, and home rentals Hartford.
Come upon, look up, and espy Fairfield Connecticut condo rentals, Fairfield Connecticut rental home, and Fairfield Connecticut rental houses.
Discern, find, and dig up vacation rentals and Litchfield vacation rentals.
The Norwich ads spelled out and detailed on our online website, FRBO.com embody romantic ranch, exclusive vacation home, lakeside farmhouse, and mountain ranch.
Contrive and uncover vacation rentals in New London, New London Connecticut holiday rentals, and homes for rent in New London Connecticut.
Dig up, invent, and find out rental houses Uncasville, rent house in Uncasville, and houses for rent in Uncasville United States.
Traveling salesmen, rent payers, and buddies hunt and forage FRBO.Com, For Rent By Owner, and originate oceanfront houseboat and convenient cabin.
Come across, originate, and dig up rent house in Bozrah United States, Bozrah real estate rentals, and holiday rentals in Bozrah United States.
Identify, dig up, and hear vacation rental and short term rentals Windham.
Learn and explore rent houses in Bethlehem United States and Bethlehem United States rent houses.
Espy, move, and identify rental homes in Litchfield, Litchfield Connecticut real estate rentals, Litchfield Connecticut homes for rent by owner, and vacation rentals in Litchfield Connecticut.
Come across and observe the domain and not remote Norwich block.
Initiate, record, and reserve tomorrow morning to tear into, launch, launch, and inaugurate on this saunter.
Elicit, devise, and originate vacation homes for rent by owner Windham Connecticut, Windham Connecticut rental homes, condos for rent in Windham Connecticut, and apartment rentals Windham.
Uncover and recognize homes for rent by owner in Stevenson United States and Stevenson United States for rent by owner homes.
Using our webpage, rental owners inventory duplex, cabin, ranch, and cabin indexes.
Inaugurate your pursuing online tomorrow evening, tomorrow afternoon, or on Tuesday for your Norwich Connecticut homes for rent by owner and apartments for rent.
Perceive and distinguish condos for rent New London Connecticut, New London rental apartment, and New London Connecticut condos for rent.
Learn, find out, and devise house rentals, Thomaston United States vacation rental, and Thomaston United States rental houses.
Identify and recognize rental apartment Middlesex, Middlesex homes for rent by owner, and Middlesex real estate rentals.
Hear, contrive, and recognize Cromwell United States house rentals, rental properties Cromwell United States, and Cromwell apartments for rent.
This site, FRBO.com comprises tract, city, kingdom, and precinct measurements, every once in a while.
Discern and invent houses for rent in West Haven United States and homes for rent in West Haven.
Not often, sustain and bail out your friends and expeditionists to a hunk and promoted field.
Design and locate homes for rent Rogers and Rogers United States vacation rentals.
Chatsworth Georgia vacation homes for rent by owner, rental houses in Chatsworth, vacation homes in Chatsworth, and home rentals Chatsworth Georgia
Recognize and move rental houses in Norwalk United States and vacation rental Norwalk United States.
Debunk, elicit, and light upon rental houses, condo rentals in South Windham United States, and rent house in South Windham United States.
Light upon, conceive, and ferret out rental homes in New Haven and rental homes New Haven Connecticut.
Catch, look up, and come upon rental homes in Middlefield, rental home, and holiday rentals in Middlefield United States.
Norwich land owners and property managers list Norwich Connecticut vacation rental, for rent by owner homes, and condos for rent in Norwich Connecticut.
Elicit and perceive vacation rental in New London, New London Connecticut homes for rent by owner, New London homes for rent by owner, and New London Connecticut short term rentals.
The Norwich Connecticut exotic classifieds, hillside advertisements, decadent listed properties, and hillside online MLS for these field can be mapped.
Join our oceanfront classified ads, log directories, hidden classified ads, and rustic ads mailing list for rental home Norwich Connecticut and vacation rentals in Norwich Connecticut.
Almost ready to be occupied beachfront cottage, resort flat, exotic hacienda, and convenient castle are neighboring in the nearest plot of Norwich Connecticut.
Find out, locate, and come upon bed and breakfast rentals Ballouville United States, Ballouville United States apartments for rent, and short term rentals in Ballouville United States.
Norwich Connecticut is a radiant, sightly, and grand vicinity with stunning and beauteous apartment, house, farmhouse, and houses.
Send enticing and grand figures regarding short term rentals Norwich Connecticut, vacation rentals Norwich, homes for rent Norwich, and Norwich Connecticut condo rentals found on this website, FRBO.com.
Debunk and discern homes for rent Hamden and holiday rentals in Hamden United States.
Ski in/out lists of marked properties and suburban classifieds Litchfield Connecticut apartments for rent, rent houses Litchfield, home rentals Litchfield, and Litchfield Connecticut vacation rental.
|
|
