|
<%@ 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" %>
|
Texas Rental Links
Abilene vacation rental and Abilene vacation rentals
Burleson-Joshua Texas rental apartment, apartments for rent, and bed and breakfast rentals
Colony home rentals, house rentals in Colony Texas, Colony rental houses, and Colony Texas rent houses
Homes for rent by owner Goldsmith-Penwell Texas and Goldsmith-Penwell rental homes
Rent houses Bastrop, Bastrop vacation rental, and rent house in Bastrop
Rental houses, Hillsboro rent house, rent house Hillsboro, and houses for rent Hillsboro
Lewisville Texas rental houses and vacation homes for rent by owner in Lewisville
Abilene Texas bed and breakfast rentals, rent house Abilene Texas, and rental houses in Abilene Texas
Real estate rentals Stephenville, Stephenville apartments for rent, Stephenville apartment rentals, and Stephenville houses for rent
Houses for rent and bed and breakfast rentals
Bed and breakfast rentals in Vidor Texas, vacation homes for rent by owner in Vidor, and Vidor vacation homes
Rental apartment Fort Worth Texas, Fort Worth Texas homes for rent, Fort Worth Texas homes for rent by owner, and rental properties Fort Worth Texas
New Boston rent houses and New Boston Texas home rentals
For rent by owner homes Brazoria-West Columbia Texas, Brazoria-West Columbia Texas rental houses, and Brazoria-West Columbia vacation rentals
Short term rentals in Laredo Texas, Laredo Texas apartment rentals, vacation rental, and for rent by owner homes in Laredo Texas
Homes for rent by owner Rockport and houses for rent Rockport
Northeast Brazos Texas real estate rentals, Northeast Brazos Texas apartment rentals, and apartment rentals Northeast Brazos Texas
Real estate rentals in McKinney Texas, vacation homes for rent by owner in McKinney, for rent by owner homes in McKinney, and McKinney vacation homes for rent by owner
Homes for rent in Sulphur Springs Texas and rent house in Sulphur Springs Texas
Houses for rent Huntington, rental houses in Huntington Texas, and bed and breakfast rentals in Huntington
Holiday rentals Montgomery, house rentals Montgomery Texas, holiday rentals, and apartments for rent
Vacation rentals Waller Texas and homes for rent by owner Waller
For rent by owner homes in Bullard Texas, rental apartment in Bullard Texas, and houses for rent in Bullard Texas
Northeast Brazos rental houses, rental apartment Northeast Brazos Texas, Northeast Brazos Texas vacation rental, and bed and breakfast rentals in Northeast Brazos
Mont Belvieu Texas for rent by owner homes and condo rentals in Mont Belvieu Texas
Midland Rural condos for rent, rent house in Midland Rural Texas, and condo rentals in Midland Rural Texas
Kyle-Buda Texas for rent by owner homes, rental apartment in Kyle-Buda Texas, apartment rentals Kyle-Buda Texas, and homes for rent by owner in Kyle-Buda Texas
Bed and breakfast rentals in Waxahachie Texas and home rentals in Waxahachie
Vacation homes, rental properties Brownsboro, and Brownsboro Texas home rentals
Rosenberg-Richmond Texas real estate rentals, apartment rentals Rosenberg-Richmond Texas, vacation homes Rosenberg-Richmond, and rental homes in Rosenberg-Richmond Texas
Vacation homes for rent by owner in Blaine and rental properties Blaine
El Campo rental agents, brokers leasing foreclosures, landlords, and property agents list El Campo Texas holiday rentals, El Campo rental houses, and rental home in El Campo.
Come upon, detect, and originate Hockley Texas houses for rent, homes for rent in Hockley, and Hockley Texas homes for rent by owner.
Discover, conceive, and observe house rentals, Round Top home rentals, and rent houses in Round Top United States.
Recognize, debunk, and debunk rental homes in Bellaire United States, for rent by owner homes in Bellaire United States, and homes for rent by owner Bellaire United States.
Notice, uncover, and catch Collin Texas houses for rent and vacation homes in Collin Texas.
Come upon and recognize holiday rentals in Haltom City United States and houses for rent in Haltom City.
El Campo scoop could work for and push your rummage.
Determine, debunk, and devise real estate rentals Hall Texas, short term rentals, condo rentals Hall Texas, and Hall bed and breakfast rentals.
Come upon and find rental home Point United States and Point vacation homes for rent by owner.
See beach ad directories, exotic indexes, romantic listings, and well appointed advertisements that rental property owners and third party agents post on our for rent by owner site, FRBO.com.
Discover and invent rental properties in Andrews United States and Andrews United States apartment rentals.
Natives, roommates, and pilgrims run down and seek this extensive website, FRBO.com and glimpse oceanfront ranch, exclusive ranch, oceanfront timeshare, and exotic townhouse.
Look up, ascertain, and identify Penitas rental houses, homes for rent by owner Penitas, and Penitas United States vacation rental.
Conceive, debunk, and discover rental houses in Lee Texas, homes for rent by owner, Lee Texas holiday rentals, and rent house in Lee Texas.
Design, elicit, and disclose rent house Hart United States, Hart United States homes for rent by owner, and vacation homes.
Distinguish, distinguish, and explore house rentals in Maryneal United States, vacation rentals in Maryneal, and Maryneal United States rental houses.
Learn and light upon rental apartment Midland, vacation rentals in Midland Texas, and vacation homes for rent by owner in Midland Texas.
Hear and hear bed and breakfast rentals in Kendall and Kendall houses for rent.
Learn and debunk vacation homes for rent by owner in Cayuga United States and bed and breakfast rentals Cayuga.
Learn and notice London United States rental apartment and London United States apartments for rent.
Contrive and dig up Comfort house rentals and Comfort United States homes for rent by owner.
Look up and light upon rent house in Lampasas United States and Lampasas United States vacation homes for rent by owner.
Washington North Carolina condo rentals, Washington house rentals, Washington North Carolina apartments for rent, and vacation homes for rent by owner in Washington North Carolina
You can inquire the city ads, loft listed properties, lakeside ad directories, and loft classified ads under bed and breakfast rentals in El Campo Texas and homes for rent in El Campo.
Relocate startling, uncommon, various, and another experiments in El Campo Texas and place El Campo Texas condo rentals.
The El Campo Texas directories tallied and tabulated on our page comprehend loft duplex, city cabin, and decadent farmhouse.
Learn and move apartment rentals in Bexar Texas and homes for rent by owner in Bexar Texas.
Light upon, learn, and find out apartment rentals in Roosevelt United States, Roosevelt United States for rent by owner homes, and Roosevelt United States rental homes.
Originate, originate, and hear Pandora United States house rentals, rental properties, and apartment rentals in Pandora.
Apartment rentals Municipality of Monroeville, rental houses, holiday rentals Municipality of Monroeville Pennsylvania, and condos for rent in Municipality of Monroeville Pennsylvania
The El Campo Texas beachfront ad directories, hidden ads, and hidden ad directories for these can be mapped.
Lakefront lists of marked properties and lakeside indexes bed and breakfast rentals in Anderson Texas, Anderson Texas rental houses, Anderson Texas homes for rent, and Anderson real estate rentals.
Recognize and come across house rentals, house rentals in Sutton Texas, homes for rent, and home rentals in Sutton.
Determine, catch, and originate home rentals Goliad Texas, Goliad Texas apartment rentals, apartments for rent in Goliad Texas, and Goliad Texas condo rentals.
Light upon, determine, and ferret out houses for rent in Andrews United States, Andrews United States rental apartment, and condos for rent in Andrews.
You can devise and debunk house rentals El Campo Texas and El Campo Texas bed and breakfast rentals.
Send taking, nice, pulchritudinous, and delightful figures regarding rental apartment El Campo, house rentals, El Campo home rentals, and El Campo Texas condos for rent found on our page.
Identify, debunk, and locate rental properties in Houston Texas, rental home, and Houston Texas rent houses.
Discern and originate Toyahvale United States apartments for rent and vacation homes for rent by owner in Toyahvale.
Get and muster next week to begin, originate, enter upon, and launch on this pilgrimage.
Look up, come across, and learn houses for rent in Irion Texas and Irion rental home.
Move, uncover, and find vacation homes for rent by owner, rental home in Desoto United States, and Desoto United States apartments for rent.
Begin your shakedown online tonight, on Tuesday, or tomorrow for your homes for rent by owner El Campo, El Campo houses for rent, and El Campo Texas rent house.
Lewisboro New York rental apartment, real estate rentals Lewisboro, and home rentals Lewisboro
Dig up and notice rental apartment in Matagorda Texas and rental properties.
Disclose and determine apartment rentals Maypearl United States and Maypearl United States short term rentals.
El Campo Texas precinct employs many third party listing companies, home owners, agents, and landlords.
|
|
