Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T09:07:49.660' ,`MLSNumber` = '23976472' ,`ListAgentFullName` = 'Javier Sepulveda' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781614' ,`Longitude` = '-95.363202' ,`PhotoCount` = '13' ,`PostalCode` = '77009' ,`RoomCount` = '8' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Freeman' ,`StreetNumber` = '2314' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '988' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great location, Location !! Location !!! 7mins to downtown, 7mins to Minute Maid Park, 5mins to U of H, 1min walking to the MetroRail stop on Main St and 3 mins to Hwy45 . This property is a grate starter home / investment with a great view of downtown Houston. With a 500 sq foot 2 bed Apartment. Never flooded .. Lots of potential investment, Airbnb, rentals or to build a half million dollar home near Downtown Houston with out the excess expenses' ,`Acres` = '0.0769' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 2C BLK 63-7 ALLEN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KETELSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Allen' ,`TaxAmount` = '3397' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1925' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084935' WHERE `Matrix_Unique_ID` = '201612197' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T10:13:53.540' ,`MLSNumber` = '94288335' ,`ListAgentFullName` = 'Danielle Talerico' ,`ListOfficeName` = 'Texas Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.691352' ,`Longitude` = '-95.897655' ,`PhotoCount` = '32' ,`PostalCode` = '77441' ,`RoomCount` = '7' ,`ListPrice` = '655000.00' ,`Status` = 'Active' ,`StreetName` = 'Syms St' ,`StreetNumber` = '8411' ,`StreetSuffix` = 'Street' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1857' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ZONED RESIDENTIAL OR COMMERCIAL! GREAT VISIBILITY FROM FM 1093 IN FAST GROWING TOWN OF FULSHEAR. BUILT IN 2003 AND SITUATED ON.4477 ACRE OF LAND. THIS WONDERFUL HOME OFFERS THREE BEDROOMS AND TWO FULL BATH. NO CARPET. CORNOR WOOD BURINING FIREPLACE WITH GRANITE ACCENTS. ENJOY THE BEAUTIFUL COVERED PORCH IN FRONT AND SPACIOUS COVERED PATIO IN THE BACKYARD. GREAT FOR ENTERTAINING. FRESHLY PAINTED INSIDE AND OUT, INCLUDING ALL DOORS AND BASEBOARDS! BENEFIT FROM THE OPPORTUITY TO PROSPER IN THE PRESIGIOUS FORT BEND COUNTY!' ,`Acres` = '0.4477' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '0029 C FULSHEAR, ACRES 0.4477' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'C Fulshear' ,`TaxAmount` = '8417' ,`TaxRate` = '1.9979' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084935' WHERE `Matrix_Unique_ID` = '209025095' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T10:34:25.090' ,`MLSNumber` = '72327720' ,`ListAgentFullName` = 'Casey Copley' ,`ListOfficeName` = 'Live Oak Real Estate Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.458820' ,`Longitude` = '-94.176983' ,`PhotoCount` = '16' ,`PostalCode` = '77656' ,`RoomCount` = '4' ,`ListPrice` = '117900.00' ,`Status` = 'Active' ,`StreetName` = 'FM 2937' ,`StreetNumber` = '8335' ,`StreetSuffix` = '' ,`City` = 'Silsbee' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '669' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute Tiny Home secluded in the middle of 1.92 acres surrounded by mature shade trees. Front of the Land has been left wooded to shield from the highway. Home was built in 2019. Home has central air and heat that is All electric with wood burning stove for additional heat. Open concept kitchen dining and living room with ease access to Bedrooms and Bathroom.' ,`Acres` = '' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Aprox 1.92 acres from AB 40 O C Nelson' ,`LotDesciption` = 'Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '252 - Silsbee' ,`SchoolElementary` = 'SILSBEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SILSBEE HIGH SCHOOL' ,`SchoolMiddle` = 'EDWARDS-JOHNSON MEMORIAL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Out Of Town' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675084935' WHERE `Matrix_Unique_ID` = '211587421' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T09:25:39.900' ,`MLSNumber` = '13214134' ,`ListAgentFullName` = 'Brandi Cunda' ,`ListOfficeName` = 'Country Pride Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.967741' ,`Longitude` = '-96.646113' ,`PhotoCount` = '16' ,`PostalCode` = '77957' ,`RoomCount` = '5' ,`ListPrice` = '229999.00' ,`Status` = 'Active' ,`StreetName` = 'Sunset' ,`StreetNumber` = '802' ,`StreetSuffix` = 'Drive' ,`City` = 'Edna' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2893' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This cozy, but spacious and almost 2,900 sq ft 5 bedroom - 3 1/2 bath home is ready for a new family. The home features a nice size living and dining area, huge upstairs bedroom/mancave, large kitchen with granite countertops, tile backsplash, gas cooktop and dishwasher. The oversize primary bedroom also offers a large bathroom with a double vanity. There is lots of storage space through the home. A back porch with endless possibilities and space for entertaining family and friends. Bonus lot next door (stipulations apply) This home is a must see!' ,`Acres` = '0.24' ,`Area` = '67' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TEXANA TERRACE, BLOCK 4, LOT 6, ACRES 0.24' ,`LotDesciption` = 'Corner' ,`LotSize` = '10454' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '246 - Edna' ,`SchoolElementary` = 'EDNA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'EDNA HIGH SCHOOL' ,`SchoolMiddle` = 'EDNA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Texana Terrace' ,`TaxAmount` = '4316' ,`TaxRate` = '2.1055' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084935' WHERE `Matrix_Unique_ID` = '212234627' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T09:45:27.620' ,`MLSNumber` = '93028656' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.064001' ,`Longitude` = '-95.367890' ,`PhotoCount` = '9' ,`PostalCode` = '77373' ,`RoomCount` = '13' ,`ListPrice` = '380990.00' ,`Status` = 'Active' ,`StreetName` = 'Aspen Vista' ,`StreetNumber` = '22907' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fall in love with this stunning Lake Ridge Builders Home in Breckenridge Park. Resting on a spacious lot, this 3-sided brick home boasts a premium elevation, no front neighbors, full gutters, wrought iron spindles, faux wood blinds, an open great room, and a covered patio. Master new recipes in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. The spa-like primary suite features dual vanities, a 42” tub, and a separate shower. Commuters enjoy quick access to the Grand Parkway and the Hardy Toll Road. Residents are only a short distance from a variety of shopping centers, restaurants, and entertainment, including Old Town Spring and The Woodlands Mall. Students attend schools in the highly acclaimed Spring ISD. This could be your dream home – call now!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 26 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Breckenridge Park' ,`TaxAmount` = '' ,`TaxRate` = '3.06' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675084936' WHERE `Matrix_Unique_ID` = '212303222' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T10:01:04.917' ,`MLSNumber` = '42094436' ,`ListAgentFullName` = 'Marcey Nelson' ,`ListOfficeName` = 'The Cox Company Real Estate Gr' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.735871' ,`Longitude` = '-94.901327' ,`PhotoCount` = '21' ,`PostalCode` = '77351' ,`RoomCount` = '6' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Crystal Creek' ,`StreetNumber` = '163' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2367' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Austin stone home with metal roof, 3/2 with attached carport with storage area attached. Property is completely fenced with storage building, wrap around porch with backyard patio area. Open concept with split floor plan, large breakfast bar, Austin stone fire place. Oversized bedrooms with plenty of storage. Country kitchen and dining area. If your looking for country living close to town this it!' ,`Acres` = '0.67' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CRYSTAL CREEK FOREST LOT 6-A, 6-B N/PT & 7-A PT' ,`LotDesciption` = 'Corner' ,`LotSize` = '29185' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Crystal Creek Forest' ,`TaxAmount` = '5201' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084936' WHERE `Matrix_Unique_ID` = '212356533' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T09:43:01.560' ,`MLSNumber` = '18584194' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.064262' ,`Longitude` = '-95.367808' ,`PhotoCount` = '8' ,`PostalCode` = '77373' ,`RoomCount` = '11' ,`ListPrice` = '351990.00' ,`Status` = 'Active' ,`StreetName` = 'Alpine Valley' ,`StreetNumber` = '22902' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1865' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The house is under construction. Make unforgettable memories in this lovely Pride Builders home in Breckenridge Park. Resting on an oversized cul-de-sac lot, this 3-sided brick home boasts a premium elevation, tile flooring, full gutters, a sprinkler system, wrought iron spindles, faux wood blinds, and a covered patio. Master new recipes in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. The tranquil primary suite features a 42” tub and separate shower. Commuters enjoy quick access to the Grand Parkway and the Hardy Toll Road. Residents are only a short distance from a variety of shopping centers, restaurants, and entertainment, including Old Town Spring and The Woodlands Mall. Students attend schools in the acclaimed Spring ISD. This could be your dream home – call now!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'Pride Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Breckenridge Park' ,`TaxAmount` = '' ,`TaxRate` = '3.06' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675084936' WHERE `Matrix_Unique_ID` = '213792155' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T09:18:47.290' ,`MLSNumber` = '96542383' ,`ListAgentFullName` = 'Lexi Sakowitz Marek' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.038979' ,`Longitude` = '-95.180088' ,`PhotoCount` = '50' ,`PostalCode` = '77339' ,`RoomCount` = '8' ,`ListPrice` = '1399000.00' ,`Status` = 'Active' ,`StreetName` = 'Hidden Links' ,`StreetNumber` = '4206' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5255' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to the beautifully remodeled 4206 Hidden Links Court. Rivaling new construction, these stunning interiors mix traditional classic with modern touches. Located on a desirable cul-de-sac street sitting on a double lot with grand Golf Course views of the 15th hole, this home is truly an entertainers dream. This complete home renovation includes new custom cabinetry, new appliances, soft closing cabinets and drawers, marble countertops, new hardware, new windows, new garage epoxy flooring, all new pool equipment, new pool filter, all new HVACs (3), all new electrical & almost all home plumbing redone. Complete with a full entertainment wing including wet bar, wine fridge, dishwasher & outdoor patio. So much versatility! The grand media room can be utilized in so many ways including a theater space or games / arcade area. The entertaining doesn\'t stop there! Outside also includes a nicely sized pool, gazebo, fire pit, decking (new), outdoor lighting & outdoor grill space.' ,`Acres` = '0.56' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 & 8 BLK 1 KINGWOOD GREENS VLG 1 PAR R/P' ,`LotDesciption` = 'Cul-De-Sac,On Golf Course' ,`LotSize` = '24280' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '880' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingwood Greens Village 01 Prc' ,`TaxAmount` = '10075' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084936' WHERE `Matrix_Unique_ID` = '213857496' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T09:49:20.130' ,`MLSNumber` = '16578093' ,`ListAgentFullName` = 'Yesenia Cavazos' ,`ListOfficeName` = 'Premier One Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.693443' ,`Longitude` = '-94.744105' ,`PhotoCount` = '9' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '36000.00' ,`Status` = 'Active' ,`StreetName` = 'Greens Elbow' ,`StreetNumber` = '138' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1026' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy the lake and Country Lifestyle. this home has potential but needs alot of work and is being sold as-is . would make a great weekend get away ,add on and bring the family or build a new home . Possibilities are endless.' ,`Acres` = '0.4645' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'INDIAN SPRINGS LAKE ESTATES SECTION 13 LOT 76, 77 & 78' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '20234' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Indian Spgs Lake Estates Se' ,`TaxAmount` = '470' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Septic Tank,Well' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084937' WHERE `Matrix_Unique_ID` = '214335057' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T09:33:46.283' ,`MLSNumber` = '55726676' ,`ListAgentFullName` = 'Dr. Brad Mitchell' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.914290' ,`Longitude` = '-95.722928' ,`PhotoCount` = '34' ,`PostalCode` = '77433' ,`RoomCount` = '16' ,`ListPrice` = '594900.00' ,`Status` = 'Active' ,`StreetName` = 'Kohle Springs' ,`StreetNumber` = '20419' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3113' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in Miramesa\'s Canyon Lakes at Stone Gate, is this lovely 2 story clean line, contemporary home. Bright and open concept first level common areas. White kitchen. High Ceilings. Game room. Media room. Office. Note the extra details that have been added inside and outside. Custom stair railing. Custom fireplace. Custom backyard deck and porch additions. No back neighbors. Custom TV wall in the Primary. Custom wall/ceiling over the tub. Custom decorative wall(s) in upstairs bedroom. ...and so much more. For your sunset stroll, follow the path in front of the house to walk around the lake. There is a community dog park, tennis courts, play grounds, pool and community center. CFISD schools! (SEE PHOTOS for BUILDER MEASUREMENTS.)' ,`Acres` = '0.1578' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 1 MIRABELLA SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POSTMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Mirabella Sec II' ,`TaxAmount` = '10282' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084937' WHERE `Matrix_Unique_ID` = '214389069' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T09:37:46.637' ,`MLSNumber` = '54323659' ,`ListAgentFullName` = 'Ezenwanyi Abii' ,`ListOfficeName` = 'Abii Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.610977' ,`Longitude` = '-95.271276' ,`PhotoCount` = '0' ,`PostalCode` = '77075' ,`RoomCount` = '3' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Fuqua Gardens' ,`StreetNumber` = '8315' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2137' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a beautiful 2 story home in the Fuqua Gardens Subdivision. Huge potential for a first home or an investment property. \r\nAll information must be verified independently.' ,`Acres` = '0.0808' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 25 BLK 1 FUQUA GARDENS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '32' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MITCHELL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Fuqua Gardens' ,`TaxAmount` = '4479' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084937' WHERE `Matrix_Unique_ID` = '214626288' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214721823','1675084937','214721823','2022-11-28T10:44:23.710','13525900','Justin Dickey','Keller Williams Professionals','','','29.427733','-95.451362','41','77583','8','414990.00','Active','Amador Peak','10719','Drive','Rosharon','3','0','4','2349','Single-Family','Beautiful one story with four bedrooms, three full baths plus study/dining room, 2 sinks in primary bath with garden Tub and large standalone shower. utility room connect to spaces primary closet. Additional closet in primary off primary bath. High ceiling granite kitchen with deep vinderman sink 42 inch cabinets. Stainless steel five burner gas range and With microwave and dishwasher 2\" blinds along with windstorm panels. Est completion: Nov 2022','','5','Colina Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','','Alvin North','Central Gas','1','Lot 15 BLK 1 Sec 7','Subdivision Lot','7748','Survey','','950','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven','0','','','Gas Range','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Accompany,Leave Business Card','Builder','1','Traditional','Sierra Vista','','3.606','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214721844','1675084937','214721844','2022-11-28T10:27:15.340','27475869','Justin Dickey','Keller Williams Professionals','','','30.219433','-95.163798','27','77372','7','279990.00','Active','Willie Mays','15323','Court','Splendora','3','0','4','1759','Single-Family','Brand new 1 story 4 bedroom 3 bath 2 car garage. Colina Home features granite, kitchen includes recess lighting. high ceilings, laminated vinyl (wood look) flooring throughout the home, 2\" blinds throughout the home, Stainless Steel Appliances including 5 burner gas range, 42\" cabinets, Large single bowl under-mount kitchen sink. Ceramic tile backsplash in kitchen & bathrooms. Masterbath features a large garden tub with separate shower, dual marble vanities, large walk-in closet. 10-year warranty on frame and foundation, 25-year warranty on roof, and 30-year warranty on Hardi Plank. Covered back patio and extreme energy efficiencies to reduce cost. This Home is Move in read November 2022. Call to schedule a showing now. Photos are representative.','','40','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','','Cleveland Area','Central Gas','1','Lot 29 Block 3 Section 4','Subdivision Lot','7400','Survey','','360','1','To Be Built/Under Construction','2','','0','','','Gas Range','','Composition','47 - Splendora','PEACH CREEK ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Accompany','Builder','1','Traditional','Splendora Fields','','2.48','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214722088','1675084937','214722088','2022-11-28T10:28:28.657','64941888','Justin Dickey','Keller Williams Professionals','','','30.219433','-95.163798','27','77372','7','274990.00','Active','Willie Mays','15332','Court','Splendora','3','0','4','1759','Single-Family','Brand new 1 story 4 bedroom 3 bath 2 car garage. Colina Home features granite, kitchen includes recess lighting. high ceilings, laminated vinyl (wood look) flooring throughout the home, 2\" blinds throughout the home, Stainless Steel Appliances including 5 burner gas range, 42\" cabinets, Large single bowl under-mount kitchen sink. Ceramic tile backsplash in kitchen & bathrooms. Masterbath features a large garden tub with separate shower, dual marble vanities, large walk-in closet. 10-year warranty on frame and foundation, 25-year warranty on roof, and 30-year warranty on Hardi Plank. Covered back patio and extreme energy efficiencies to reduce cost. This Home is Move in ready November 2022. Call to schedule a showing now. Photos are representative.','','40','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','','Cleveland Area','Central Gas','1','Lot 32 Block 1 Section 4','Subdivision Lot','7400','Survey','','360','1','To Be Built/Under Construction','2','','0','','','Gas Range','','Composition','47 - Splendora','PEACH CREEK ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Accompany','Builder','1','Traditional','Splendora Fields','','2.48','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214723835','1675084937','214723835','2022-11-28T10:30:09.307','18882085','Justin Dickey','Keller Williams Professionals','','','30.218954','-95.163831','19','77372','13','289990.00','Active','Willie Mays','15340','Court','Splendora','3','1','5','1978','Single-Family','Brand new beautiful 2 story 5 bedroom 3 1/2 bath and 2 car garage. Colina Home features 42\'\' cabients, quartz/granite kitchen countertops, kitchen includes recess lighting, high ceilings, laminated vinyl (wood look) flooring throughout the home, 2\" blinds throughout the home, Stainless Steel Appliances including 5 burner gas range, Large single bowl under-mount kitchen sink. Ceramic tile backsplash in kitchen & bathrooms. Masterbath features a large garden tub with separate shower, dual marble vanities, large walk-in closet. 10-year warranty on frame and foundation, 25-year warranty on roof, and 30-year warranty on Hardi Plank, and extreme energy efficiencies to reduce cost. This Home is Move in ready Nov 2022. Call to schedule a showing now','','40','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Cleveland Area','Central Gas','1','Lot 30 BLK 1 Sec 4','Subdivision Lot','9194','Survey','','360','1','To Be Built/Under Construction','2','Convection Oven','0','','','Gas Range','','Composition','47 - Splendora','PEACH CREEK ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Accompany','Builder','2','Traditional','Splendora Fields','','2.48','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214723849','1675084937','214723849','2022-11-28T10:31:26.697','6371477','Justin Dickey','Keller Williams Professionals','','','30.220247','-95.164152','19','77372','12','310266.00','Active','Willie Mays','15307','Court','Splendora','2','1','4','1978','Single-Family','Brand new beautiful 2 story 5 bedroom 3 1/2 bath and 2 car garage. Colina Home features 42\'\' cabients, quartz/granite kitchen countertops, kitchen includes recess lighting, high ceilings, laminated vinyl (wood look) flooring throughout the home, 2\" blinds throughout the home, Stainless Steel Appliances including 5 burner gas range, Large single bowl under-mount kitchen sink. Ceramic tile backsplash in kitchen & bathrooms. Masterbath features a large garden tub with separate shower, dual marble vanities, large walk-in closet. 10-year warranty on frame and foundation, 25-year warranty on roof, and 30-year warranty on Hardi Plank, and extreme energy efficiencies to reduce cost. This Home is Move in ready Nov 2022. Call to schedule a showing now','','40','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Cleveland Area','Central Gas','1','Lot 33 BLK 3 Sec 4','Subdivision Lot','15316','Survey','','360','1','To Be Built/Under Construction','2','Convection Oven','0','','','Gas Range','','Composition','47 - Splendora','PEACH CREEK ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Accompany','Builder','2','Traditional','Splendora Fields','','2.48','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214726683','1675084938','214726683','2022-11-28T10:49:20.850','76528164','Justin Dickey','Keller Williams Professionals','','','29.427598','-95.451366','46','77583','8','419990.00','Active','Amador Peak','10807','Drive','Rosharon','3','0','4','2543','Single-Family','Beautiful one story with 4 bedrooms, 3 full baths plus study/dining room. Two sinks in primary bath with garden tub and stand-alone shower with seat, XLarge primary closet. High ceilings throughout the home with vestibule in the entry. Granite Kitchen with deep under-mount sink. 42” cabinets, Stainless Steel 5 burner gas range, microwave and dishwasher 2” blinds standard along with windstorm panels, large covered patio. EST Completion 11/30/22. PICTURES ARE REPRESENTATIVE- Not the actual home.','','5','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Alvin North','Central Gas','1','Lot 20 BLK 1 Sec 7','Subdivision Lot','7927','Appraisal District','','900','1','To Be Built/Under Construction','3','Gas Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Accompany,Leave Business Card','Builder','1','Contemporary/Modern','Sierra Vista','','3.6','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214760716','1675084938','214760716','2022-11-28T10:33:22.663','37938688','Justin Dickey','Keller Williams Professionals','','','30.219471','-95.162923','27','77372','7','274990.00','Active','Cooperstown','26218','Way','Splendora','3','0','4','1759','Single-Family','Brand new 1 story 4 bedroom 3 bath 2 car garage. Colina Home features granite, kitchen includes recess lighting. high ceilings, laminated vinyl (wood look) flooring throughout the home, 2\" blinds throughout the home, Stainless Steel Appliances including 5 burner gas range, 42\" cabinets, Large single bowl under-mount kitchen sink. Ceramic tile backsplash in kitchen & bathrooms. Masterbath features a large garden tub with separate shower, dual marble vanities, large walk-in closet. 10-year warranty on frame and foundation, 25-year warranty on roof, and 30-year warranty on Hardi Plank. Covered back patio and extreme energy efficiencies to reduce cost. This Home is Move in ready November 2022. Call to schedule a showing now. Photos are representative.','','40','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','','Cleveland Area','Central Gas','1','Lot 9 Block 1 Section 4','Subdivision Lot','12668','Survey','','360','1','To Be Built/Under Construction','2','','0','','','Gas Range','','Composition','47 - Splendora','PEACH CREEK ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Accompany','Builder','1','Traditional','Splendora Fields','','2.48','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214822975','1675084938','214822975','2022-11-28T10:42:37.477','80816806','Justin Dickey','Keller Williams Professionals','','','29.436920','-95.438449','32','77583','5','359990.00','Active','Tioga View','1907','Drive','Rosharon','2','0','3','1830','Single-Family','Colina Homes- Single Story: Elegant entry with coffered tall ceilings, bedrooms, 2 baths, located in our gated section of Sierra Vista! Spacious master closet with his/her sinks and sep. tub and shower. Tons of Beautiful Finishes included!!Gorgeous kitchen with stunning cabinets, granite and tiled backslash , Perfect backyard and a Large covered back patio ready for weekend BBQ\'s. You\'re going to Love it! Situated in one of Rosharon\'s best communities. and offers everything your are looking in a family friendly community- amenities located in Sterling Lakes - the spashpad, fitness center, Basketball Court, Lakes & Parks. Crystal Lagoon coming soon! Close to Pearland, Alvin, Manvel, Lake Jackson, 30 minutes from Downtown Houston. SHOP AND WORK IN THE CITY AND COME HOME TO A QUIET PEACEFUL COMMUNITY @ SIERRA VISTA!','','5','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','','Alvin North','Central Gas','1','Lot 31 Block 3 Sec 7','Subdivision Lot','7920','Survey','','1100','1','To Be Built/Under Construction','2','','0','','','Freestanding Range,Gas Cooktop,Gas Range','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Accompany','Builder','1','Traditional','Sierra Vista West','','3.6','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214823215','1675084938','214823215','2022-11-28T10:52:41.023','34550784','Justin Dickey','Keller Williams Professionals','','','29.437789','-95.434424','50','77583','8','439990.00','Active','Amador Peak','10626','','Rosharon','3','1','4','2922','Single-Family','This gorgeous Colina Home has Amazing offerings! When you walk through the front door you will feel right at home. This home offers 4bedrooms,3.5bathrooms,dining & 3car garage! The living room, kitchen,area are open to each other with high ceilings. The kitchen features oversized island with seating,42\" cabinetry,& spacious walk in pantry. The primary bedroom is tucked away in the back of home with a spacious en suite bathroom & walk in closet. There is a Huge covered back patio great for grilling and fun. Rosharon\'s best communities offering everything a family friendly community want + amenities located in Sterling Lakes, with a spashpad, fitness center,Basketball Court, Lakes & Parks. Crystal Lagoon coming soon! Close to Pearland, Alvin,Manvel, Lake Jackson,30 minutes from Downtown Houston. SHOP AND WORK IN THE CITY AND\r\nCOME HOME TO A QUIET PEACEFUL COMMUNITY @ SIERRA VISTA!','','5','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Alvin North','Central Gas','1','Lot 7 Block 2 Sec 7','Subdivision Lot','7500','Survey','','1100','1','To Be Built/Under Construction','3','Gas Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Accompany,Leave Business Card','Builder','2','Contemporary/Modern','Sierra Vista','','','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214823387','1675084938','214823387','2022-11-28T10:39:44.320','48536807','Justin Dickey','Keller Williams Professionals','','','30.220678','-95.161691','31','77372','10','279990.00','Active','Honus Wagner','25433','Way','Splendora','2','0','3','1754','Single-Family','Brand new beautiful 1 story 3 bedroom 2 bath with a study and 2 car garage. Colina Home features gray cabients, quartz kitchen countertops, kitchen includes recess lighting, high ceilings, laminated vinyl (wood look) flooring throughout the home, 2\" blinds throughout the home, Stainless Steel Appliances including 5 burner gas range, 42\" gray cabinets in kitchen, Large single bowl under-mount kitchen sink. Ceramic tile backsplash in kitchen & bathrooms. Masterbath features a large garden tub with separate shower, dual marble vanities, large walk-in closet. 10-year warranty on frame and foundation, 25-year warranty on roof, and 30-year warranty on Hardi Plank. Covered back patio and extreme energy efficiencies to reduce cost. This Home is Move in ready Nov/Dec 2022.\r\nPHOTOS ARE REPRESENTATIVE','','40','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','','Cleveland Area','Central Gas','1','Lot 15 Block 3 Sec 4','Subdivision Lot','11974','Survey','','360','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','47 - Splendora','PEACH CREEK ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Accompany','Builder','1','Traditional','Splendora Fields','','2.48','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215122798','1675084938','215122798','2022-11-28T10:43:35.910','93093626','Nancy Lawrence','Lawrence Realty','','','31.323870','-95.452698','20','75835','3','65000.00','Active','Harold','409','Street','Crockett','2','0','3','1355','Single-Family','HANDYMAN SPECIAL! \r\n Don’t miss out on this opportunity to purchase a nice house that is priced to sell! This three bedroom, two bath home would be a great fixer-upper to rent or resale on the open market. Guests will take notice to the covered carport out front of the house and the large cyclone fenced in backyard for pets. A small shed is located behind the home along with a storage room off of the back porch. Inside the home is a large 53-gallon Rheem hot water heater, electric stove and five window units in each of the primary rooms/bedrooms. Give us a call today to look at this new listing because it won’t last long!','0.251','41','','','','','No Disclosures','','','','Crockett Area','Window Unit','0','PINECREST LOT S PT OF 10 BLK A','Other','10934','Appraisal District','','','0','','0','','0','','','','','Composition','57 - Crockett','CROCKETT ELEMENTARY SCHOOL (CROCKETT)','CROCKETT HIGH SCHOOL (CROCKETT)','CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)','Appointment Required','Appraisal District','1','Traditional','NONE','1217','2.3627','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully