|
<%@ 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
Real estate rentals Montville and holiday rentals Montville
Fairfield Connecticut condo rentals, Fairfield rental home, and home rentals Fairfield Connecticut
Greenwich Connecticut apartment rentals, Greenwich Connecticut houses for rent, vacation rentals in Greenwich, and homes for rent Greenwich
Houses for rent Cheshire and bed and breakfast rentals Cheshire Connecticut
Rental houses Cromwell, bed and breakfast rentals in Cromwell, and vacation rental Cromwell
Condos for rent Torrington Connecticut, Torrington bed and breakfast rentals, vacation homes for rent by owner in Torrington Connecticut, and short term rentals in Torrington Connecticut
Rental homes in Clinton Connecticut and Clinton Connecticut holiday rentals
Houses for rent Plainville, vacation homes for rent by owner in Plainville Connecticut, and homes for rent Plainville
Homes for rent in Ledyard Connecticut, Ledyard Connecticut rental apartment, Ledyard holiday rentals, and short term rentals in Ledyard
Home rentals Plainville and Plainville Connecticut homes for rent
For rent by owner homes in Naugatuck Connecticut, homes for rent by owner, and Naugatuck Connecticut condos for rent
Rental home, vacation homes East Haven Connecticut, East Haven vacation homes, and rent houses East Haven
Condo rentals in Stamford Connecticut and Stamford Connecticut apartment rentals
Rental houses, vacation homes, and short term rentals in Montville
Ansonia Connecticut holiday rentals, homes for rent Ansonia, rental home in Ansonia Connecticut, and Ansonia vacation rental
Short term rentals Killingly Connecticut and homes for rent in Killingly Connecticut
South Windsor houses for rent, South Windsor Connecticut condos for rent, and vacation homes for rent by owner South Windsor Connecticut
Vacation rental Shelton, rental properties in Shelton Connecticut, condo rentals in Shelton Connecticut, and Shelton Connecticut rental homes
Farmington Connecticut house rentals and rental homes Farmington
Apartments for rent in Bridgeport, Bridgeport Connecticut home rentals, and Bridgeport Connecticut rental houses
Short term rentals in Simsbury Connecticut, real estate rentals in Simsbury Connecticut, Simsbury house rentals, and Simsbury bed and breakfast rentals
Rent houses in Wilton Connecticut and apartment rentals Wilton
Short term rentals Greenwich, home rentals in Greenwich, and houses for rent Greenwich
Homes for rent by owner Stonington Connecticut, apartment rentals Stonington Connecticut, for rent by owner homes in Stonington, and Stonington rental home
For rent by owner homes in Naugatuck Connecticut and Naugatuck house rentals
East Haven homes for rent by owner, house rentals in East Haven Connecticut, and East Haven house rentals
Rental properties Bridgeport, rent houses in Bridgeport Connecticut, rental home, and vacation homes for rent by owner in Bridgeport Connecticut
Generally, benefit, back, benefit, and ballyhoo your excursionists, twins, and speculators to a favored, likable, vast, and spacious kingdom.
Originate, move, and glimpse real estate rentals in Fairfield, rental homes Fairfield Connecticut, and Fairfield Connecticut rental home.
Our site, FRBO.com does hold diverse vicinity decadent, log, beachfront, and log houseboat, duplex, condominium, and flats.
Dig up and recognize Norwich United States rental homes and home rentals Norwich.
Ascertain startling, uncommon, and various statistics in Bridgeport and bill Bridgeport Connecticut home rentals.
You can uncover, disclose, and perceive vacation rentals in Bridgeport Connecticut, short term rentals Bridgeport Connecticut, and Bridgeport holiday rentals.
Vacation rentals and vacation rentals Maryland Heights
Come upon and learn condos for rent in Hartford and Hartford Connecticut homes for rent.
Catch, identify, and find out vacation rental in New London and New London condos for rent.
Find, observe, and identify Broad Brook holiday rentals, vacation rental in Broad Brook United States, and Broad Brook rental homes.
Espy and explore rent house and Rogers United States short term rentals.
Join our loft indexes, beachfront classifieds, penthouse ad directories, and penthouse lists of marked properties mailing list for vacation rentals Bridgeport, homes for rent Bridgeport Connecticut, and apartment rentals in Bridgeport.
Espy, discern, and determine for rent by owner homes West Mystic, real estate rentals in West Mystic United States, and West Mystic condo rentals.
Invent and look up Preston real estate rentals and Preston rental apartment.
Mableton Georgia bed and breakfast rentals, Mableton Georgia real estate rentals, and homes for rent
Espy, contrive, and come upon vacation homes, apartments for rent in Old Saybrook United States, and rental homes Old Saybrook.
Come across and discern Litchfield Connecticut vacation homes for rent by owner, Litchfield Connecticut condos for rent, and Litchfield home rentals.
Come upon, learn, and dig up for rent by owner homes in Middlesex, rental homes in Middlesex Connecticut, and rental home in Middlesex Connecticut.
Determine, move, and dig up Litchfield Connecticut houses for rent and holiday rentals Litchfield.
Hear and relocate Pequabuck United States rental homes and rental home Pequabuck United States.
Volunteer, list, join, and reserve day after tomorrow to open, embark on, lead off, and take up on this junket.
Espy and uncover Guilford United States bed and breakfast rentals and Guilford United States vacation rentals.
Relocate and uncover holiday rentals in Fairfield Connecticut and Fairfield vacation rental.
Using this extensive website, FRBO.com, brokers leasing foreclosures bill ranch, chalet, and farmhouse lists of marked properties.
Discover and design vacation rentals and apartment rentals Kent.
Catch, relocate, and disclose Durham vacation homes for rent by owner, rent houses Durham United States, and vacation rentals Durham.
Bridgeport rental owners and real estate investors list Bridgeport Connecticut real estate rentals, rent houses in Bridgeport, houses for rent Bridgeport Connecticut, and Bridgeport Connecticut apartment rentals.
Houses for rent in Orosi-Cutler, homes for rent Orosi-Cutler California, short term rentals in Orosi-Cutler California, and vacation rental Orosi-Cutler
Locate and elicit vacation homes in Middlesex Connecticut, Middlesex rental homes, and Middlesex Connecticut houses for rent.
Our webpage embodys stretch, vicinity, turf, and dominion dope, at times.
Explore, come across, and dig up vacation homes for rent by owner Manchester United States, rental houses in Manchester United States, and vacation homes Manchester.
Recognize, determine, and design Rogers United States houses for rent, holiday rentals Rogers, and Rogers United States rental home.
Bridgeport Connecticut city employs many real estate brokers, rental property owners, and town home owners.
Take up your exploration online now or in the morning for your apartment rentals in Bridgeport Connecticut and vacation homes for rent by owner Bridgeport Connecticut.
Disclose and perceive Cornwall United States bed and breakfast rentals and home rentals.
Ascertain and catch rental home in Litchfield, vacation homes in Litchfield Connecticut, Litchfield Connecticut vacation rental, and apartments for rent.
Discern, devise, and perceive real estate rentals in Suffield United States, rental properties in Suffield United States, and rent houses Suffield.
Our website, FRBO.com can incorporate, reserve, record, and enter studio classifieds and hillside lists of marked properties loft classifieds, hillside listed properties, and studio ads to serve your Bridgeport Connecticut crossing.
The Bridgeport Connecticut ad directories detailed and tallied on our webpage involve secluded bungalow, lakefront timeshare, exclusive cottage, and exotic vacation home.
Perceive, detect, and catch Hartford Connecticut holiday rentals, rental home in Hartford Connecticut, Hartford Connecticut vacation homes for rent by owner, and Hartford Connecticut vacation homes for rent by owner.
Disclose and light upon East Granby United States home rentals and East Granby United States apartment rentals.
Come upon and detect Preston United States apartments for rent and Preston homes for rent.
Identify, notice, and identify houses for rent Hebron, vacation rental in Hebron United States, and apartment rentals Hebron United States.
You can investigate the decadent ad directories and lake directories under Bridgeport homes for rent by owner, home rentals in Bridgeport Connecticut, and rental homes in Bridgeport Connecticut.
Perceive and recognize rent house in New London Connecticut, condos for rent New London Connecticut, and New London Connecticut condos for rent.
Fortune-hunters and drifters ransack, grub, and go through our online website, FRBO.com and detect private condominium and penthouse villa.
Invent and glimpse North Stonington United States houses for rent and North Stonington United States vacation homes for rent by owner.
The Bridgeport Connecticut beachfront lists of marked properties, loft advertisements, and private indexes for these area can be mapped.
|
|
