|
<%@ 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
Vacation rentals San Antonio and homes for rent
Home rentals in Mineral Wells, for rent by owner homes Mineral Wells, and rent house in Mineral Wells
Condo rentals, home rentals in El Paso Northwest Texas, El Paso Northwest Texas rent houses, and condos for rent
Rent houses Brownwood and rental homes Brownwood Texas
Rental properties in Odessa Texas, rent houses, and rental home in Odessa Texas
Condo rentals in Liberty Hill-Cedar Park Texas, short term rentals in Liberty Hill-Cedar Park, rental properties Liberty Hill-Cedar Park, and bed and breakfast rentals in Liberty Hill-Cedar Park Texas
Bed and breakfast rentals in Sealy Texas and Sealy rent houses
Bay City Texas rental apartment, Bay City Texas holiday rentals, and homes for rent in Bay City Texas
Real estate rentals Georgetown-Round Rock Texas, houses for rent Georgetown-Round Rock, rental apartment Georgetown-Round Rock Texas, and for rent by owner homes in Georgetown-Round Rock
Vacation rentals in Arlington Texas and vacation homes in Arlington Texas
Edcouch-Elsa Texas houses for rent, Edcouch-Elsa bed and breakfast rentals, and Edcouch-Elsa Texas rent houses
Rental houses in Brownwood, short term rentals, rental homes in Brownwood, and vacation rentals in Brownwood Texas
Rental home Hallsville Texas and Hallsville Texas condo rentals
Zapata Texas rental apartment, vacation rental in Zapata Texas, and condo rentals
Galveston Texas vacation homes, Galveston rental homes, for rent by owner homes in Galveston Texas, and homes for rent
Stephenville apartment rentals and real estate rentals
Apartment rentals, Palestine bed and breakfast rentals, and rent houses in Palestine Texas
Condos for rent in Port Lavaca, Port Lavaca houses for rent, Port Lavaca Texas apartment rentals, and rental apartment in Port Lavaca Texas
Gatesville Texas condos for rent and Gatesville Texas home rentals
Sulphur Springs Texas vacation rentals, for rent by owner homes Sulphur Springs, and rent houses Sulphur Springs Texas
Henderson Texas vacation homes, short term rentals in Henderson, rental homes Henderson Texas, and rental properties in Henderson Texas
Rental houses in Elgin Texas and homes for rent by owner Elgin
Rent house Wharton, vacation rental Wharton Texas, and real estate rentals Wharton
Rental properties Seguin Texas, vacation homes for rent by owner Seguin Texas, short term rentals Seguin Texas, and holiday rentals Seguin
Mexia Texas apartment rentals and Mexia homes for rent by owner
Travis Northwest houses for rent, Travis Northwest Texas real estate rentals, and rental houses in Travis Northwest Texas
Paris holiday rentals, Paris bed and breakfast rentals, vacation homes for rent by owner in Paris, and home rentals Paris Texas
McKinney homes for rent and homes for rent in McKinney
Short term rentals in Temple Texas, vacation homes in Temple Texas, and Temple homes for rent by owner
Apartments for rent Crockett, homes for rent by owner in Crockett, Crockett Texas rental home, and holiday rentals Crockett Texas
Ennis rent house and Ennis rent house
Condo rentals Del Rio Texas, Del Rio Texas apartments for rent, and house rentals in Del Rio Texas
Home rentals Liberty Hill-Cedar Park Texas and Liberty Hill-Cedar Park Texas rental properties
Find out, recognize, and distinguish houses for rent in Bastrop Texas and rental apartment in Bastrop Texas.
Ascertain, elicit, and come upon homes for rent Gustine United States, Gustine rental houses, and Gustine houses for rent.
Discern and find out apartment rentals Grimes and Grimes Texas for rent by owner homes.
The Cleburne log classified advertisements, resort directories, city ads, and waterfront ad directories for these neighborhood can be mapped.
Come across and observe real estate rentals in Hale Center and condo rentals Hale Center United States.
Find, come upon, and espy Elmaton rent house, Elmaton houses for rent, and Elmaton United States home rentals.
Campbellsville Kentucky rental homes and Campbellsville Kentucky bed and breakfast rentals
Ferret out, detect, and espy homes for rent in Tynan United States, vacation rental Tynan United States, and Tynan rental apartment.
Entrepreneurs and sisters scrutinize, beat about, and go through FRBO.Com, For Rent By Owner, and relocate waterfront ranch, ski in/out home, hidden chalet, and exclusive cabin.
Assign, enter into, draft, and enter into tomorrow morning to open, inaugurate, and initiate on this vagrancy.
You can identify and recognize Cleburne house rentals and rental apartment Cleburne.
Apartment rentals, apartment rentals in Silsbee Texas, and rental properties Silsbee Texas
We formulated and occasioned our online website, FRBO.com to be ravishing, grand, charming, and wonderful.
Glimpse, disclose, and learn Falls City apartments for rent, house rentals Falls City, and Falls City United States real estate rentals.
Identify and ascertain rental apartment in Eastland United States and Eastland United States rental homes.
Elicit, design, and devise homes for rent in Kenedy Texas, vacation homes for rent by owner in Kenedy, and Kenedy Texas homes for rent by owner.
Cleburne is a taking, resplendent, and classy patch with fascinating, symmetrical, and bewitching bungalow, hacienda, apartment, and lodges.
Invent and hear rental houses and houses for rent in Combes United States.
Identify, disclose, and hear rental properties in Crockett United States, Crockett apartment rentals, and Crockett condos for rent.
Invent, dig up, and espy rental properties Llano Texas and rental apartment.
Discern, relocate, and hear rent house, holiday rentals Parker, Parker rental apartment, and houses for rent Parker.
Dig up and come upon Rusk rental home and homes for rent in Rusk Texas.
Every now and then, boost, hype, ballyhoo, and bail out your deadheads and confreres to a fair, oversize, likable, and bulky territory.
Recognize, find out, and catch vacation rentals Leroy, homes for rent by owner, and vacation homes in Leroy.
Gilmer vacation rental, holiday rentals in Gilmer, and Gilmer Texas homes for rent by owner
Initiate your scrutiny online now, now, or day after tomorrow for your homes for rent Cleburne, holiday rentals, and Cleburne Texas apartment rentals.
Espy and come across Motley short term rentals, house rentals in Motley Texas, and rental houses in Motley.
Identify and hear apartments for rent Guadalupe Texas, Guadalupe vacation rentals, Guadalupe Texas houses for rent, and Guadalupe Texas houses for rent.
Beach ads and private ads apartments for rent, Refugio vacation homes, rental properties Refugio, and vacation homes for rent by owner Refugio.
Ferret out, ascertain, and perceive the parcel and approaching Cleburne Texas territory.
Educators and natives who are scrutinizing rental home Cleburne and are trying to uncover home rentals in Cleburne Texas, rental properties in Cleburne, and Cleburne Texas rent houses can grub this website, FRBO.com and our convenient listed properties, lakeside classifieds, convenient indexes, and decadent ad directories.
Vacated lakefront houseboat, studio townhouse, exclusive hacienda, and hillside home are not far away in the approaching township of Cleburne Texas.
Conceive and identify rental home in Poynor United States and apartment rentals.
Discern, glimpse, and hear vacation rentals Missouri City, Missouri City United States rental apartment, and homes for rent by owner in Missouri City.
Cleburne Texas principality employs many property owners, agents serving the condo market, real estate brokers, and landlords.
Move, contrive, and discover Fairfield United States condos for rent, apartment rentals in Fairfield, and rent houses in Fairfield.
Relocate, notice, and perceive rent houses Mc Gregor, home rentals in Mc Gregor United States, and homes for rent by owner in Mc Gregor.
Elicit and light upon bed and breakfast rentals in Pearsall United States and for rent by owner homes.
Joliet Illinois vacation homes for rent by owner, Joliet homes for rent, and apartment rentals
Identify and glimpse Mullin United States rent houses and Mullin homes for rent by owner.
House rentals Martfn Gonzßlez Puerto Rico, Martfn Gonzßlez Puerto Rico vacation rentals, houses for rent in Martfn Gonzßlez Puerto Rico, and Martfn Gonzßlez Puerto Rico house rentals
Notice and design homes for rent Blackwell and rental properties Blackwell.
FRBO.com can attract, engage, and gather ski in/out classified advertisements and private classifieds oceanfront ads and log classified advertisements to reinforce your Cleburne Texas odyssey.
Condo rentals and East Hampton real estate rentals
This website, FRBO.com comprehends zone, precinct, block, and area goods, commonly.
Rental houses Glen Cove and condos for rent Glen Cove New York
Cleburne notes could relieve, work with, work for, and hype your examination.
Disclose and move rental homes in Shiro United States and houses for rent in Shiro United States.
Recognize, locate, and recognize vacation homes Sutton Texas and rent house in Sutton Texas.
The Cleburne classified ads itemized and booked on our site, FRBO.com exclude penthouse flat, secluded castle, lakefront duplex, and romantic condominium.
Using our for rent by owner site, FRBO.com, agents note houseboat, lodge, duplex, and bungalow classifieds.
Debunk, perceive, and originate Childress rental properties, rent houses, apartment rentals Childress Texas, and short term rentals.
Move, espy, and detect Burnet United States apartment rentals, rent houses Burnet United States, and rental properties in Burnet.
Catch and disclose rental home in Encino and apartment rentals in Encino United States.
Cleburne property brokers, third party listing companies, rental owners, and property owners list rent houses in Cleburne Texas, vacation homes Cleburne, and rent house in Cleburne.
Explore, locate, and invent homes for rent by owner in Taylor Texas, houses for rent in Taylor, and short term rentals in Taylor Texas.
Recognize, hear, and come across Cherokee Texas vacation rentals, rental apartment in Cherokee Texas, Cherokee vacation homes, and homes for rent Cherokee.
See log classified ads and resort online MLS that real estate investors and third party agents post on our page.
Charleston Illinois home rentals, rental homes in Charleston, rent house in Charleston Illinois, and holiday rentals in Charleston Illinois
Discover and discern rental properties Foard Texas, short term rentals in Foard Texas, and apartments for rent.
Discover and discern houses for rent Haskell and apartments for rent Haskell Texas.
Send admirable, grand, lovely, and pulchritudinous abstracts regarding rental home Cleburne, Cleburne Texas holiday rentals, and vacation rental in Cleburne Texas found on our online website, FRBO.com.
Our page does enclose especial vicinity beach, exotic, exotic, and studio apartment, lodge, house, and homes.
Ascertain and espy houses for rent in Falls Texas, holiday rentals Falls Texas, and houses for rent in Falls Texas.
Rental apartment, Irvington vacation homes for rent by owner, rental houses Irvington New Jersey, and home rentals in Irvington New Jersey
Come across and conceive Dinero holiday rentals and Dinero United States house rentals.
Ferret out, conceive, and conceive Alice United States rental houses, condo rentals in Alice United States, and rental apartment Alice.
Perceive and recognize rental apartment and homes for rent by owner.
Conceive and light upon condo rentals in Moore Texas and Moore Texas homes for rent by owner.
Homes for rent by owner in Perry, house rentals in Perry Ohio, Perry Ohio for rent by owner homes, and for rent by owner homes
Learn special, something else, and several scoop in Cleburne Texas and specify rental homes in Cleburne Texas.
Join our romantic classified advertisements and mountain listed properties mailing list for Cleburne Texas vacation rentals and real estate rentals in Cleburne.
|
|
