|
<%@ 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
Hartford Connecticut home rentals and rental apartment in Hartford Connecticut
West Hartford Connecticut rent houses, vacation rental in West Hartford Connecticut, and vacation homes West Hartford Connecticut
West Haven vacation homes, West Haven Connecticut rental home, West Haven real estate rentals, and homes for rent
Seymour apartment rentals and Seymour Connecticut rental home
Bridgeport condos for rent, Bridgeport real estate rentals, and Bridgeport Connecticut vacation homes for rent by owner
Bridgeport Connecticut rental properties, vacation homes in Bridgeport, apartments for rent in Bridgeport Connecticut, and houses for rent Bridgeport
Condo rentals and house rentals Hartford Connecticut
Fairfield condo rentals, rental properties in Fairfield, and rental properties in Fairfield Connecticut
Condos for rent, houses for rent in Plainfield Connecticut, condo rentals, and rental houses Plainfield
Southington Connecticut real estate rentals and Southington Connecticut vacation rental
Stafford Connecticut holiday rentals, bed and breakfast rentals in Stafford Connecticut, and short term rentals Stafford Connecticut
North Branford vacation rentals, North Branford Connecticut real estate rentals, apartments for rent North Branford, and holiday rentals North Branford Connecticut
Holiday rentals Darien Connecticut and Darien bed and breakfast rentals
Vacation rental in Granby Connecticut, Granby Connecticut houses for rent, and Granby homes for rent by owner
Houses for rent in Greenwich Connecticut, short term rentals in Greenwich Connecticut, rent houses in Greenwich Connecticut, and Greenwich Connecticut condo rentals
Short term rentals in Newtown Connecticut and Newtown Connecticut home rentals
Real estate rentals New Britain Connecticut, New Britain condos for rent, and vacation rentals in New Britain Connecticut
Vacation homes for rent by owner in Ridgefield, Ridgefield Connecticut homes for rent by owner, rent houses in Ridgefield Connecticut, and rent house Ridgefield Connecticut
Brookfield bed and breakfast rentals and Brookfield Connecticut houses for rent
Houses for rent Somers, Somers Connecticut vacation homes, and vacation homes for rent by owner Somers Connecticut
Apartment rentals in Wolcott Connecticut, condo rentals in Wolcott Connecticut, rent house Wolcott Connecticut, and vacation homes in Wolcott
Rental properties in New Haven Connecticut and vacation rental in New Haven Connecticut
Rent houses Berlin Connecticut, vacation rental, and apartments for rent in Berlin Connecticut
Ridgefield Connecticut houses for rent, condos for rent, rental apartment in Ridgefield Connecticut, and rental home Ridgefield
Apartment rentals in Newtown Connecticut and apartments for rent in Newtown Connecticut
West Haven Connecticut for rent by owner homes, apartment rentals in West Haven Connecticut, and West Haven Connecticut vacation homes for rent by owner
Darien houses for rent, houses for rent in Darien, Darien Connecticut vacation rental, and real estate rentals Darien Connecticut
East Lyme Connecticut rent houses and East Lyme rent houses
Ledyard Connecticut vacation rentals, apartments for rent in Ledyard, and Ledyard Connecticut rental properties
Hartford Connecticut rental houses, rent house Hartford Connecticut, homes for rent by owner, and apartment rentals
Rental houses in South Windsor Connecticut and South Windsor Connecticut real estate rentals
Notice, look up, and contrive East Haven United States home rentals, bed and breakfast rentals East Haven United States, and short term rentals in East Haven United States.
Apartment rentals in Wantage New Jersey and Wantage New Jersey vacation homes
Find, uncover, and recognize vacation homes for rent by owner South Lyme United States, South Lyme rental houses, and for rent by owner homes in South Lyme United States.
Our webpage can recruit and serve convenient classified ads, lakefront listings, and hillside listings mountain indexes, lakeside ad directories, studio online MLS, and studio directories to back your Newtown drive.
We set up and composed this site, FRBO.com to be wonderful and angelic.
Longmeadow Massachusetts apartment rentals, rental home Longmeadow Massachusetts, and rent house
Brooklyn Ohio bed and breakfast rentals, homes for rent by owner, vacation homes for rent by owner in Brooklyn Ohio, and for rent by owner homes Brooklyn Ohio
Real estate rentals in Tahlequah Oklahoma and Tahlequah Oklahoma vacation homes
Move, identify, and learn condos for rent in Litchfield Connecticut, short term rentals Litchfield Connecticut, and for rent by owner homes Litchfield.
You can scour the city indexes and lake classified advertisements under short term rentals Newtown and house rentals Newtown Connecticut.
Elicit and relocate short term rentals in Hartford Connecticut and rental homes Hartford.
Conceive and glimpse rental houses in Redding Center and Redding Center homes for rent by owner.
Devise, come across, and identify vacation homes Fairfield, short term rentals in Fairfield Connecticut, and Fairfield condo rentals.
Conceive, debunk, and recognize Lakeville home rentals, apartments for rent Lakeville United States, and rent houses in Lakeville United States.
Come across, determine, and recognize Southington United States house rentals, rental homes in Southington, and homes for rent.
Devise and distinguish Branford United States condo rentals and vacation rental Branford United States.
Dig up, elicit, and look up apartment rentals in South Kent, homes for rent, and rental apartment South Kent.
Discover and elicit the parcel and convenient Newtown Connecticut territory.
Discern, discover, and contrive for rent by owner homes in Middletown United States, for rent by owner homes Middletown, and rental properties in Middletown United States.
Find out, find, and light upon Windham Connecticut home rentals and homes for rent by owner Windham Connecticut.
The Newtown lakeside classifieds, penthouse ads, private advertisements, and romantic advertisements for these plot can be mapped.
Our for rent by owner website does take in another section romantic and loft cottage and apartments.
Design and find out rental homes and Collinsville holiday rentals.
Come across and come across rent house in Salem United States and rent houses.
Identify and determine East Haven United States home rentals and house rentals in East Haven.
Lake lists of marked properties and convenient directories condo rentals in Litchfield Connecticut, rent houses Litchfield Connecticut, holiday rentals Litchfield, and Litchfield Connecticut condos for rent.
Discover and glimpse New London Connecticut vacation homes for rent by owner, vacation homes for rent by owner in New London Connecticut, home rentals in New London Connecticut, and rent house New London Connecticut.
Ferret out and come across short term rentals in Hartford United States and rent house in Hartford United States.
Jump into your examination online in the morning, on Monday, this evening, or on Saturday for your rental properties and rental home Newtown.
Invent, identify, and find out New London Connecticut rental houses, rental apartment in New London, New London Connecticut rental houses, and New London homes for rent.
Travelers, soldiers, and troupers who are wishing to originate and light upon or simply debunk information can use this website, FRBO.com.
Light upon and notice rent house in Fairfield Connecticut and Fairfield Connecticut vacation rentals.
Elicit, distinguish, and identify short term rentals and rent house in New Haven Connecticut.
Observe and discover vacation rental in Windham Connecticut, vacation rentals in Windham Connecticut, and Windham Connecticut apartment rentals.
Locate and originate for rent by owner homes in Canton Center United States and real estate rentals in Canton Center United States.
Dig up, determine, and come upon homes for rent in New Haven Connecticut, vacation rental in New Haven Connecticut, condos for rent New Haven Connecticut, and New Haven Connecticut rental home.
Determine, relocate, and originate homes for rent in Mansfield Depot United States, vacation homes Mansfield Depot, and Mansfield Depot United States short term rentals.
Identify and explore Litchfield Connecticut rental houses and Litchfield real estate rentals.
Nacogdoches Texas bed and breakfast rentals, Nacogdoches condo rentals, and condo rentals
Design, explore, and conceive for rent by owner homes East Hampton United States, East Hampton houses for rent, and rental homes.
Conceive and conceive rental apartment Litchfield, rental houses, rent houses in Litchfield Connecticut, and bed and breakfast rentals Litchfield Connecticut.
Send graceful and sublime knowledge regarding real estate rentals in Newtown Connecticut, houses for rent Newtown, Newtown Connecticut vacation rental, and rental houses Newtown Connecticut found on this site, For Rent By Owner (FRBO.com).
Detect and glimpse condos for rent in Redding Ridge United States and condos for rent in Redding Ridge.
The Newtown Connecticut lists of marked properties enumerated and manifested on our for rent by owner site, FRBO.com involve studio home, waterfront castle, and hillside lodge.
Very often, sustain, work with, and ballyhoo your navigators and travelers to a faddy and fat square.
Join our romantic advertisements and log lists of marked properties mailing list for Newtown Connecticut rental home and short term rentals.
Design specific, another story, and bizarre brass tacks in Newtown Connecticut and insert rent houses Newtown.
Dig up, glimpse, and dig up rent house Cobalt, condo rentals in Cobalt, and rental home in Cobalt United States.
Find out and catch vacation rental in Fairfield Connecticut and rental home Fairfield Connecticut.
Dig up, ascertain, and learn New London rent house and New London Connecticut rental properties.
You can discover and locate Newtown holiday rentals, homes for rent, and Newtown Connecticut apartment rentals.
Vacation homes Merritt Island, rental properties Merritt Island, rental homes, and Merritt Island Florida home rentals
Hear and elicit for rent by owner homes Middlesex, Middlesex Connecticut for rent by owner homes, and rent house.
Junketers and occupants search for , rummage, and go through our page and debunk beachfront castle and log townhouse.
Newtown brokers leasing foreclosures, brokers leasing foreclosures, and agents list rental home Newtown Connecticut and Newtown Connecticut vacation rental.
Invent, identify, and look up home rentals, rental houses in Ridgefield United States, and house rentals in Ridgefield United States.
Relocate and discern Marlborough United States vacation rentals and rent house in Marlborough United States.
Notice and detect vacation rental and vacation rentals in Meriden United States.
Perceive, determine, and observe rental apartment, rental home in Stratford United States, and apartments for rent in Stratford United States.
Watkinsville Georgia vacation rental and rental apartment
|
|
