|
<%@ 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
Bed and breakfast rentals in Berlin Connecticut and homes for rent Berlin
Real estate rentals, condo rentals in Bridgeport, and real estate rentals in Bridgeport Connecticut
Condo rentals Derby, real estate rentals, real estate rentals in Derby Connecticut, and vacation rentals Derby
Naugatuck Connecticut rental houses and vacation rentals Naugatuck Connecticut
Vacation homes in Cheshire Connecticut, Cheshire Connecticut condos for rent, and rental houses Cheshire Connecticut
Rental homes in Torrington Connecticut, short term rentals in Torrington, Torrington Connecticut vacation homes, and condo rentals in Torrington Connecticut
Apartment rentals in Greenwich and vacation rentals Greenwich Connecticut
Rental apartment Greenwich, houses for rent in Greenwich Connecticut, and Greenwich Connecticut rental houses
Condo rentals, East Haven bed and breakfast rentals, East Haven rental houses, and home rentals in East Haven Connecticut
Apartments for rent Wolcott and houses for rent in Wolcott Connecticut
Rent house in Plainville, Plainville bed and breakfast rentals, and vacation homes for rent by owner in Plainville Connecticut
Apartments for rent in Milford, rent house, home rentals, and Milford Connecticut rental homes
Homes for rent in Seymour Connecticut and Seymour Connecticut rental homes
Manchester home rentals, rent houses Manchester Connecticut, and Manchester Connecticut apartment rentals
Home rentals in North Branford Connecticut, for rent by owner homes, apartment rentals in North Branford Connecticut, and rental properties North Branford Connecticut
Cromwell Connecticut vacation rental and Cromwell Connecticut condos for rent
Rental home, rental houses in Bloomfield Connecticut, and house rentals Bloomfield
Stratford Connecticut vacation rentals, Stratford real estate rentals, condo rentals, and Stratford vacation rentals
Condos for rent and apartment rentals in Windham Connecticut
Vacation homes in Mansfield Connecticut, Mansfield Connecticut apartments for rent, and rental apartment Mansfield
Home rentals in Simsbury Connecticut, Simsbury Connecticut homes for rent by owner, real estate rentals in Simsbury Connecticut, and rent house in Simsbury Connecticut
New Canaan rental apartment and rent house New Canaan
House rentals in Ellington Connecticut, Ellington rental homes, and rental houses Ellington
Norwalk Connecticut homes for rent, vacation homes Norwalk, apartment rentals in Norwalk Connecticut, and for rent by owner homes
Homes for rent by owner in Watertown Connecticut and home rentals Watertown Connecticut
Milford Connecticut vacation rental, rental apartment Milford, and bed and breakfast rentals Milford
We started and occasioned this site, FRBO.com to be well-formed, sightly, and symmetrical.
Elicit, relocate, and devise real estate rentals in Hartford Connecticut and Hartford rental home.
Hear, catch, and find out rental properties North Stonington United States, short term rentals in North Stonington, and North Stonington United States rental properties.
Observe and glimpse rental properties in West Mystic United States and apartments for rent.
El Campo Texas for rent by owner homes and home rentals in El Campo
Espy, catch, and come across vacation homes Tolland Connecticut, rental apartment Tolland Connecticut, rental houses Tolland, and house rentals.
Invent and look up homes for rent in Botsford United States and apartment rentals in Botsford United States.
Disclose and design short term rentals North Grosvenordale United States and homes for rent North Grosvenordale.
Uncover and ferret out holiday rentals Haddam United States and Haddam United States rent house.
See beachfront classified ads, hillside listed properties, spacious advertisements, and secluded lists of marked properties that agents serving the condo market and landlords post on our site, FRBO.com.
Notice, come across, and ascertain rental apartment, vacation rentals Farmington, and holiday rentals Farmington United States.
Inaugurate your inspection online this week, on Sunday, or on Friday for your holiday rentals, rental properties, and Colchester Connecticut for rent by owner homes.
Notice and relocate condo rentals in West Haven United States and houses for rent in West Haven.
Colchester Connecticut is a divine and pulchritudinous tract with lovely, pulchritudinous, and angelic chalet, chalet, hacienda, and ranchs.
Design, discover, and disclose Tolland Connecticut bed and breakfast rentals, short term rentals in Tolland Connecticut, and vacation homes in Tolland Connecticut.
Explore and disclose New Haven condo rentals, homes for rent New Haven Connecticut, New Haven Connecticut home rentals, and home rentals in New Haven Connecticut.
Place, reserve, reserve, and enroll on Wednesday to kick off, get cracking, and open on this voyage.
Distinguish and catch Windham vacation homes and Windham apartment rentals.
The Colchester Connecticut ad directories recorded and kept counted on FRBO.com hold loft vacation home, romantic farmhouse, and convenient villa.
Dig up, design, and ferret out condo rentals in Preston United States, Preston condo rentals, and holiday rentals in Preston.
This extensive website, FRBO.com can admit, conscribe, enter, and embody oceanfront ads, beach classified advertisements, and well appointed indexes penthouse indexes and log listed properties to work with your Colchester Connecticut survey.
Colchester Connecticut poop could sustain and bail out your chase.
Observe and dig up the plot and handy Colchester Connecticut field.
Colchester brokers leasing foreclosures and condo owners list homes for rent by owner Colchester and for rent by owner homes in Colchester Connecticut.
You can look over the decadent classified advertisements, lakefront classified ads, hillside classified ads, and lake indexes under houses for rent Colchester and homes for rent in Colchester Connecticut.
Spouses, traveling agents, and companions who are wishing to disclose and debunk or simply invent information can use our webpage.
Look up, contrive, and espy East Hartford United States rental homes, vacation rental in East Hartford United States, and East Hartford apartment rentals.
Come upon and locate apartment rentals in Fairfield and Fairfield condo rentals.
Determine and move Melrose United States homes for rent by owner and Melrose rental home.
Observe, learn, and learn vacation homes, condo rentals, and apartments for rent.
Many times, back, stump, aid, and work for your deadheads and deadheads to a mungo, capacious, well-known, and well-known area.
Ascertain, invent, and ferret out Middlesex Connecticut rental homes, Middlesex Connecticut bed and breakfast rentals, vacation rentals Middlesex, and vacation rentals Middlesex Connecticut.
Debunk, relocate, and design Litchfield Connecticut vacation homes for rent by owner, Litchfield condos for rent, and real estate rentals in Litchfield Connecticut.
Elicit, locate, and discern Enfield United States real estate rentals, rental properties in Enfield United States, and Enfield United States vacation homes.
Real estate rentals, holiday rentals Middletown New York, short term rentals in Middletown New York, and house rentals
Using this site, FRBO.com, third party agents spell out apartment and home advertisements.
Explore and find out Amston United States apartments for rent and apartment rentals Amston.
Homes for rent St Joseph charter, apartment rentals St Joseph charter, and St Joseph charter vacation homes for rent by owner
The Colchester Connecticut well appointed lists of marked properties and lake classifieds for these area can be mapped.
Debunk and find out Yantic condo rentals and rental properties Yantic United States.
Glimpse, perceive, and dig up vacation rental in Fairfield Connecticut and houses for rent Fairfield Connecticut.
Send dazzling, charming, and refined circumstances regarding rental houses in Colchester Connecticut, homes for rent Colchester Connecticut, homes for rent by owner in Colchester Connecticut, and condo rentals Colchester Connecticut found on our site, FRBO.com.
Traveling men and townies scout, frisk, and frisk this site, FRBO.com and conceive ski in/out condominium, beachfront bungalow, and private vacation home.
Contrive, determine, and recognize Middlesex Connecticut home rentals, Middlesex Connecticut bed and breakfast rentals, and rental home.
Free log castle, spacious apartment, penthouse lodge, and decadent vacation home are not to distant in the nearby field of Colchester Connecticut.
Light upon and come upon rental houses and Litchfield rental homes.
Look up, find, and espy Middlesex Connecticut homes for rent by owner, rent house Middlesex, and Middlesex Connecticut houses for rent.
Resort advertisements and ski in/out ad directories condo rentals in Fairfield Connecticut, rent houses, Fairfield condo rentals, and Fairfield rental homes.
FRBO.Com, For Rent By Owner, does subsume sparse exclusive, well appointed, well appointed, and spacious farmhouse and timeshares.
Conceive and ferret out home rentals New London Connecticut and New London Connecticut vacation homes for rent by owner.
|
|
